package com.desksoft.ecommerce.entity.logistics.dto;

import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class VipcardExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public VipcardExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andCardnoIsNull() {
            addCriterion("CardNo is null");
            return (Criteria) this;
        }

        public Criteria andCardnoIsNotNull() {
            addCriterion("CardNo is not null");
            return (Criteria) this;
        }

        public Criteria andCardnoEqualTo(String value) {
            addCriterion("CardNo =", value, "cardno");
            return (Criteria) this;
        }

        public Criteria andCardnoNotEqualTo(String value) {
            addCriterion("CardNo <>", value, "cardno");
            return (Criteria) this;
        }

        public Criteria andCardnoGreaterThan(String value) {
            addCriterion("CardNo >", value, "cardno");
            return (Criteria) this;
        }

        public Criteria andCardnoGreaterThanOrEqualTo(String value) {
            addCriterion("CardNo >=", value, "cardno");
            return (Criteria) this;
        }

        public Criteria andCardnoLessThan(String value) {
            addCriterion("CardNo <", value, "cardno");
            return (Criteria) this;
        }

        public Criteria andCardnoLessThanOrEqualTo(String value) {
            addCriterion("CardNo <=", value, "cardno");
            return (Criteria) this;
        }

        public Criteria andCardnoLike(String value) {
            addCriterion("CardNo like", value, "cardno");
            return (Criteria) this;
        }

        public Criteria andCardnoNotLike(String value) {
            addCriterion("CardNo not like", value, "cardno");
            return (Criteria) this;
        }

        public Criteria andCardnoIn(List<String> values) {
            addCriterion("CardNo in", values, "cardno");
            return (Criteria) this;
        }

        public Criteria andCardnoNotIn(List<String> values) {
            addCriterion("CardNo not in", values, "cardno");
            return (Criteria) this;
        }

        public Criteria andCardnoBetween(String value1, String value2) {
            addCriterion("CardNo between", value1, value2, "cardno");
            return (Criteria) this;
        }

        public Criteria andCardnoNotBetween(String value1, String value2) {
            addCriterion("CardNo not between", value1, value2, "cardno");
            return (Criteria) this;
        }

        public Criteria andUseridIsNull() {
            addCriterion("UserID is null");
            return (Criteria) this;
        }

        public Criteria andUseridIsNotNull() {
            addCriterion("UserID is not null");
            return (Criteria) this;
        }

        public Criteria andUseridEqualTo(String value) {
            addCriterion("UserID =", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridNotEqualTo(String value) {
            addCriterion("UserID <>", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridGreaterThan(String value) {
            addCriterion("UserID >", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridGreaterThanOrEqualTo(String value) {
            addCriterion("UserID >=", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridLessThan(String value) {
            addCriterion("UserID <", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridLessThanOrEqualTo(String value) {
            addCriterion("UserID <=", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridLike(String value) {
            addCriterion("UserID like", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridNotLike(String value) {
            addCriterion("UserID not like", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridIn(List<String> values) {
            addCriterion("UserID in", values, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridNotIn(List<String> values) {
            addCriterion("UserID not in", values, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridBetween(String value1, String value2) {
            addCriterion("UserID between", value1, value2, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridNotBetween(String value1, String value2) {
            addCriterion("UserID not between", value1, value2, "userid");
            return (Criteria) this;
        }

        public Criteria andCardtypeIsNull() {
            addCriterion("CardType is null");
            return (Criteria) this;
        }

        public Criteria andCardtypeIsNotNull() {
            addCriterion("CardType is not null");
            return (Criteria) this;
        }

        public Criteria andCardtypeEqualTo(String value) {
            addCriterion("CardType =", value, "cardtype");
            return (Criteria) this;
        }

        public Criteria andCardtypeNotEqualTo(String value) {
            addCriterion("CardType <>", value, "cardtype");
            return (Criteria) this;
        }

        public Criteria andCardtypeGreaterThan(String value) {
            addCriterion("CardType >", value, "cardtype");
            return (Criteria) this;
        }

        public Criteria andCardtypeGreaterThanOrEqualTo(String value) {
            addCriterion("CardType >=", value, "cardtype");
            return (Criteria) this;
        }

        public Criteria andCardtypeLessThan(String value) {
            addCriterion("CardType <", value, "cardtype");
            return (Criteria) this;
        }

        public Criteria andCardtypeLessThanOrEqualTo(String value) {
            addCriterion("CardType <=", value, "cardtype");
            return (Criteria) this;
        }

        public Criteria andCardtypeLike(String value) {
            addCriterion("CardType like", value, "cardtype");
            return (Criteria) this;
        }

        public Criteria andCardtypeNotLike(String value) {
            addCriterion("CardType not like", value, "cardtype");
            return (Criteria) this;
        }

        public Criteria andCardtypeIn(List<String> values) {
            addCriterion("CardType in", values, "cardtype");
            return (Criteria) this;
        }

        public Criteria andCardtypeNotIn(List<String> values) {
            addCriterion("CardType not in", values, "cardtype");
            return (Criteria) this;
        }

        public Criteria andCardtypeBetween(String value1, String value2) {
            addCriterion("CardType between", value1, value2, "cardtype");
            return (Criteria) this;
        }

        public Criteria andCardtypeNotBetween(String value1, String value2) {
            addCriterion("CardType not between", value1, value2, "cardtype");
            return (Criteria) this;
        }

        public Criteria andViptypeIsNull() {
            addCriterion("VipType is null");
            return (Criteria) this;
        }

        public Criteria andViptypeIsNotNull() {
            addCriterion("VipType is not null");
            return (Criteria) this;
        }

        public Criteria andViptypeEqualTo(String value) {
            addCriterion("VipType =", value, "viptype");
            return (Criteria) this;
        }
        public Criteria andStatusEqualTo(String value) {
            addCriterion("Status =", value, "viptype");
            return (Criteria) this;
        }
        public Criteria andViptypeNotEqualTo(String value) {
            addCriterion("VipType <>", value, "viptype");
            return (Criteria) this;
        }

        public Criteria andViptypeGreaterThan(String value) {
            addCriterion("VipType >", value, "viptype");
            return (Criteria) this;
        }

        public Criteria andViptypeGreaterThanOrEqualTo(String value) {
            addCriterion("VipType >=", value, "viptype");
            return (Criteria) this;
        }

        public Criteria andViptypeLessThan(String value) {
            addCriterion("VipType <", value, "viptype");
            return (Criteria) this;
        }

        public Criteria andViptypeLessThanOrEqualTo(String value) {
            addCriterion("VipType <=", value, "viptype");
            return (Criteria) this;
        }

        public Criteria andViptypeLike(String value) {
            addCriterion("VipType like", value, "viptype");
            return (Criteria) this;
        }

        public Criteria andViptypeNotLike(String value) {
            addCriterion("VipType not like", value, "viptype");
            return (Criteria) this;
        }

        public Criteria andViptypeIn(List<String> values) {
            addCriterion("VipType in", values, "viptype");
            return (Criteria) this;
        }

        public Criteria andViptypeNotIn(List<String> values) {
            addCriterion("VipType not in", values, "viptype");
            return (Criteria) this;
        }

        public Criteria andViptypeBetween(String value1, String value2) {
            addCriterion("VipType between", value1, value2, "viptype");
            return (Criteria) this;
        }

        public Criteria andViptypeNotBetween(String value1, String value2) {
            addCriterion("VipType not between", value1, value2, "viptype");
            return (Criteria) this;
        }

        public Criteria andPwdIsNull() {
            addCriterion("PWD is null");
            return (Criteria) this;
        }

        public Criteria andPwdIsNotNull() {
            addCriterion("PWD is not null");
            return (Criteria) this;
        }

        public Criteria andPwdEqualTo(String value) {
            addCriterion("PWD =", value, "pwd");
            return (Criteria) this;
        }

        public Criteria andPwdNotEqualTo(String value) {
            addCriterion("PWD <>", value, "pwd");
            return (Criteria) this;
        }

        public Criteria andPwdGreaterThan(String value) {
            addCriterion("PWD >", value, "pwd");
            return (Criteria) this;
        }

        public Criteria andPwdGreaterThanOrEqualTo(String value) {
            addCriterion("PWD >=", value, "pwd");
            return (Criteria) this;
        }

        public Criteria andPwdLessThan(String value) {
            addCriterion("PWD <", value, "pwd");
            return (Criteria) this;
        }

        public Criteria andPwdLessThanOrEqualTo(String value) {
            addCriterion("PWD <=", value, "pwd");
            return (Criteria) this;
        }

        public Criteria andPwdLike(String value) {
            addCriterion("PWD like", value, "pwd");
            return (Criteria) this;
        }

        public Criteria andPwdNotLike(String value) {
            addCriterion("PWD not like", value, "pwd");
            return (Criteria) this;
        }

        public Criteria andPwdIn(List<String> values) {
            addCriterion("PWD in", values, "pwd");
            return (Criteria) this;
        }

        public Criteria andPwdNotIn(List<String> values) {
            addCriterion("PWD not in", values, "pwd");
            return (Criteria) this;
        }

        public Criteria andPwdBetween(String value1, String value2) {
            addCriterion("PWD between", value1, value2, "pwd");
            return (Criteria) this;
        }

        public Criteria andPwdNotBetween(String value1, String value2) {
            addCriterion("PWD not between", value1, value2, "pwd");
            return (Criteria) this;
        }

        public Criteria andIdtypeIsNull() {
            addCriterion("IDType is null");
            return (Criteria) this;
        }

        public Criteria andIdtypeIsNotNull() {
            addCriterion("IDType is not null");
            return (Criteria) this;
        }

        public Criteria andIdtypeEqualTo(String value) {
            addCriterion("IDType =", value, "idtype");
            return (Criteria) this;
        }

        public Criteria andIdtypeNotEqualTo(String value) {
            addCriterion("IDType <>", value, "idtype");
            return (Criteria) this;
        }

        public Criteria andIdtypeGreaterThan(String value) {
            addCriterion("IDType >", value, "idtype");
            return (Criteria) this;
        }

        public Criteria andIdtypeGreaterThanOrEqualTo(String value) {
            addCriterion("IDType >=", value, "idtype");
            return (Criteria) this;
        }

        public Criteria andIdtypeLessThan(String value) {
            addCriterion("IDType <", value, "idtype");
            return (Criteria) this;
        }

        public Criteria andIdtypeLessThanOrEqualTo(String value) {
            addCriterion("IDType <=", value, "idtype");
            return (Criteria) this;
        }

        public Criteria andIdtypeLike(String value) {
            addCriterion("IDType like", value, "idtype");
            return (Criteria) this;
        }

        public Criteria andIdtypeNotLike(String value) {
            addCriterion("IDType not like", value, "idtype");
            return (Criteria) this;
        }

        public Criteria andIdtypeIn(List<String> values) {
            addCriterion("IDType in", values, "idtype");
            return (Criteria) this;
        }

        public Criteria andIdtypeNotIn(List<String> values) {
            addCriterion("IDType not in", values, "idtype");
            return (Criteria) this;
        }

        public Criteria andIdtypeBetween(String value1, String value2) {
            addCriterion("IDType between", value1, value2, "idtype");
            return (Criteria) this;
        }

        public Criteria andIdtypeNotBetween(String value1, String value2) {
            addCriterion("IDType not between", value1, value2, "idtype");
            return (Criteria) this;
        }

        public Criteria andIdcardnoIsNull() {
            addCriterion("IDCardNo is null");
            return (Criteria) this;
        }

        public Criteria andIdcardnoIsNotNull() {
            addCriterion("IDCardNo is not null");
            return (Criteria) this;
        }

        public Criteria andIdcardnoEqualTo(String value) {
            addCriterion("IDCardNo =", value, "idcardno");
            return (Criteria) this;
        }

        public Criteria andIdcardnoNotEqualTo(String value) {
            addCriterion("IDCardNo <>", value, "idcardno");
            return (Criteria) this;
        }

        public Criteria andIdcardnoGreaterThan(String value) {
            addCriterion("IDCardNo >", value, "idcardno");
            return (Criteria) this;
        }

        public Criteria andIdcardnoGreaterThanOrEqualTo(String value) {
            addCriterion("IDCardNo >=", value, "idcardno");
            return (Criteria) this;
        }

        public Criteria andIdcardnoLessThan(String value) {
            addCriterion("IDCardNo <", value, "idcardno");
            return (Criteria) this;
        }

        public Criteria andIdcardnoLessThanOrEqualTo(String value) {
            addCriterion("IDCardNo <=", value, "idcardno");
            return (Criteria) this;
        }

        public Criteria andIdcardnoLike(String value) {
            addCriterion("IDCardNo like", value, "idcardno");
            return (Criteria) this;
        }

        public Criteria andIdcardnoNotLike(String value) {
            addCriterion("IDCardNo not like", value, "idcardno");
            return (Criteria) this;
        }

        public Criteria andIdcardnoIn(List<String> values) {
            addCriterion("IDCardNo in", values, "idcardno");
            return (Criteria) this;
        }

        public Criteria andIdcardnoNotIn(List<String> values) {
            addCriterion("IDCardNo not in", values, "idcardno");
            return (Criteria) this;
        }

        public Criteria andIdcardnoBetween(String value1, String value2) {
            addCriterion("IDCardNo between", value1, value2, "idcardno");
            return (Criteria) this;
        }

        public Criteria andIdcardnoNotBetween(String value1, String value2) {
            addCriterion("IDCardNo not between", value1, value2, "idcardno");
            return (Criteria) this;
        }

        public Criteria andVipnameIsNull() {
            addCriterion("VipName is null");
            return (Criteria) this;
        }

        public Criteria andVipnameIsNotNull() {
            addCriterion("VipName is not null");
            return (Criteria) this;
        }

        public Criteria andVipnameEqualTo(String value) {
            addCriterion("VipName =", value, "vipname");
            return (Criteria) this;
        }

        public Criteria andVipnameNotEqualTo(String value) {
            addCriterion("VipName <>", value, "vipname");
            return (Criteria) this;
        }

        public Criteria andVipnameGreaterThan(String value) {
            addCriterion("VipName >", value, "vipname");
            return (Criteria) this;
        }

        public Criteria andVipnameGreaterThanOrEqualTo(String value) {
            addCriterion("VipName >=", value, "vipname");
            return (Criteria) this;
        }

        public Criteria andVipnameLessThan(String value) {
            addCriterion("VipName <", value, "vipname");
            return (Criteria) this;
        }

        public Criteria andVipnameLessThanOrEqualTo(String value) {
            addCriterion("VipName <=", value, "vipname");
            return (Criteria) this;
        }

        public Criteria andVipnameLike(String value) {
            addCriterion("VipName like", value, "vipname");
            return (Criteria) this;
        }

        public Criteria andVipnameNotLike(String value) {
            addCriterion("VipName not like", value, "vipname");
            return (Criteria) this;
        }

        public Criteria andVipnameIn(List<String> values) {
            addCriterion("VipName in", values, "vipname");
            return (Criteria) this;
        }

        public Criteria andVipnameNotIn(List<String> values) {
            addCriterion("VipName not in", values, "vipname");
            return (Criteria) this;
        }

        public Criteria andVipnameBetween(String value1, String value2) {
            addCriterion("VipName between", value1, value2, "vipname");
            return (Criteria) this;
        }

        public Criteria andVipnameNotBetween(String value1, String value2) {
            addCriterion("VipName not between", value1, value2, "vipname");
            return (Criteria) this;
        }

        public Criteria andBirthdayIsNull() {
            addCriterion("Birthday is null");
            return (Criteria) this;
        }

        public Criteria andBirthdayIsNotNull() {
            addCriterion("Birthday is not null");
            return (Criteria) this;
        }

        public Criteria andBirthdayEqualTo(Date value) {
            addCriterion("Birthday =", value, "birthday");
            return (Criteria) this;
        }

        public Criteria andBirthdayNotEqualTo(Date value) {
            addCriterion("Birthday <>", value, "birthday");
            return (Criteria) this;
        }

        public Criteria andBirthdayGreaterThan(Date value) {
            addCriterion("Birthday >", value, "birthday");
            return (Criteria) this;
        }

        public Criteria andBirthdayGreaterThanOrEqualTo(Date value) {
            addCriterion("Birthday >=", value, "birthday");
            return (Criteria) this;
        }

        public Criteria andBirthdayLessThan(Date value) {
            addCriterion("Birthday <", value, "birthday");
            return (Criteria) this;
        }

        public Criteria andBirthdayLessThanOrEqualTo(Date value) {
            addCriterion("Birthday <=", value, "birthday");
            return (Criteria) this;
        }

        public Criteria andBirthdayIn(List<Date> values) {
            addCriterion("Birthday in", values, "birthday");
            return (Criteria) this;
        }

        public Criteria andBirthdayNotIn(List<Date> values) {
            addCriterion("Birthday not in", values, "birthday");
            return (Criteria) this;
        }

        public Criteria andBirthdayBetween(Date value1, Date value2) {
            addCriterion("Birthday between", value1, value2, "birthday");
            return (Criteria) this;
        }

        public Criteria andBirthdayNotBetween(Date value1, Date value2) {
            addCriterion("Birthday not between", value1, value2, "birthday");
            return (Criteria) this;
        }

        public Criteria andSexIsNull() {
            addCriterion("Sex is null");
            return (Criteria) this;
        }

        public Criteria andSexIsNotNull() {
            addCriterion("Sex is not null");
            return (Criteria) this;
        }

        public Criteria andSexEqualTo(String value) {
            addCriterion("Sex =", value, "sex");
            return (Criteria) this;
        }

        public Criteria andSexNotEqualTo(String value) {
            addCriterion("Sex <>", value, "sex");
            return (Criteria) this;
        }

        public Criteria andSexGreaterThan(String value) {
            addCriterion("Sex >", value, "sex");
            return (Criteria) this;
        }

        public Criteria andSexGreaterThanOrEqualTo(String value) {
            addCriterion("Sex >=", value, "sex");
            return (Criteria) this;
        }

        public Criteria andSexLessThan(String value) {
            addCriterion("Sex <", value, "sex");
            return (Criteria) this;
        }

        public Criteria andSexLessThanOrEqualTo(String value) {
            addCriterion("Sex <=", value, "sex");
            return (Criteria) this;
        }

        public Criteria andSexLike(String value) {
            addCriterion("Sex like", value, "sex");
            return (Criteria) this;
        }

        public Criteria andSexNotLike(String value) {
            addCriterion("Sex not like", value, "sex");
            return (Criteria) this;
        }

        public Criteria andSexIn(List<String> values) {
            addCriterion("Sex in", values, "sex");
            return (Criteria) this;
        }

        public Criteria andSexNotIn(List<String> values) {
            addCriterion("Sex not in", values, "sex");
            return (Criteria) this;
        }

        public Criteria andSexBetween(String value1, String value2) {
            addCriterion("Sex between", value1, value2, "sex");
            return (Criteria) this;
        }

        public Criteria andSexNotBetween(String value1, String value2) {
            addCriterion("Sex not between", value1, value2, "sex");
            return (Criteria) this;
        }

        public Criteria andNationIsNull() {
            addCriterion("Nation is null");
            return (Criteria) this;
        }

        public Criteria andNationIsNotNull() {
            addCriterion("Nation is not null");
            return (Criteria) this;
        }

        public Criteria andNationEqualTo(String value) {
            addCriterion("Nation =", value, "nation");
            return (Criteria) this;
        }

        public Criteria andNationNotEqualTo(String value) {
            addCriterion("Nation <>", value, "nation");
            return (Criteria) this;
        }

        public Criteria andNationGreaterThan(String value) {
            addCriterion("Nation >", value, "nation");
            return (Criteria) this;
        }

        public Criteria andNationGreaterThanOrEqualTo(String value) {
            addCriterion("Nation >=", value, "nation");
            return (Criteria) this;
        }

        public Criteria andNationLessThan(String value) {
            addCriterion("Nation <", value, "nation");
            return (Criteria) this;
        }

        public Criteria andNationLessThanOrEqualTo(String value) {
            addCriterion("Nation <=", value, "nation");
            return (Criteria) this;
        }

        public Criteria andNationLike(String value) {
            addCriterion("Nation like", value, "nation");
            return (Criteria) this;
        }

        public Criteria andNationNotLike(String value) {
            addCriterion("Nation not like", value, "nation");
            return (Criteria) this;
        }

        public Criteria andNationIn(List<String> values) {
            addCriterion("Nation in", values, "nation");
            return (Criteria) this;
        }

        public Criteria andNationNotIn(List<String> values) {
            addCriterion("Nation not in", values, "nation");
            return (Criteria) this;
        }

        public Criteria andNationBetween(String value1, String value2) {
            addCriterion("Nation between", value1, value2, "nation");
            return (Criteria) this;
        }

        public Criteria andNationNotBetween(String value1, String value2) {
            addCriterion("Nation not between", value1, value2, "nation");
            return (Criteria) this;
        }

        public Criteria andNativedIsNull() {
            addCriterion("Native is null");
            return (Criteria) this;
        }

        public Criteria andNativedIsNotNull() {
            addCriterion("Native is not null");
            return (Criteria) this;
        }

        public Criteria andNativedEqualTo(String value) {
            addCriterion("Native =", value, "natived");
            return (Criteria) this;
        }

        public Criteria andNativedNotEqualTo(String value) {
            addCriterion("Native <>", value, "natived");
            return (Criteria) this;
        }

        public Criteria andNativedGreaterThan(String value) {
            addCriterion("Native >", value, "natived");
            return (Criteria) this;
        }

        public Criteria andNativedGreaterThanOrEqualTo(String value) {
            addCriterion("Native >=", value, "natived");
            return (Criteria) this;
        }

        public Criteria andNativedLessThan(String value) {
            addCriterion("Native <", value, "natived");
            return (Criteria) this;
        }

        public Criteria andNativedLessThanOrEqualTo(String value) {
            addCriterion("Native <=", value, "natived");
            return (Criteria) this;
        }

        public Criteria andNativedLike(String value) {
            addCriterion("Native like", value, "natived");
            return (Criteria) this;
        }

        public Criteria andNativedNotLike(String value) {
            addCriterion("Native not like", value, "natived");
            return (Criteria) this;
        }

        public Criteria andNativedIn(List<String> values) {
            addCriterion("Native in", values, "natived");
            return (Criteria) this;
        }

        public Criteria andNativedNotIn(List<String> values) {
            addCriterion("Native not in", values, "natived");
            return (Criteria) this;
        }

        public Criteria andNativedBetween(String value1, String value2) {
            addCriterion("Native between", value1, value2, "natived");
            return (Criteria) this;
        }

        public Criteria andNativedNotBetween(String value1, String value2) {
            addCriterion("Native not between", value1, value2, "natived");
            return (Criteria) this;
        }

        public Criteria andEducationIsNull() {
            addCriterion("Education is null");
            return (Criteria) this;
        }

        public Criteria andEducationIsNotNull() {
            addCriterion("Education is not null");
            return (Criteria) this;
        }

        public Criteria andEducationEqualTo(String value) {
            addCriterion("Education =", value, "education");
            return (Criteria) this;
        }

        public Criteria andEducationNotEqualTo(String value) {
            addCriterion("Education <>", value, "education");
            return (Criteria) this;
        }

        public Criteria andEducationGreaterThan(String value) {
            addCriterion("Education >", value, "education");
            return (Criteria) this;
        }

        public Criteria andEducationGreaterThanOrEqualTo(String value) {
            addCriterion("Education >=", value, "education");
            return (Criteria) this;
        }

        public Criteria andEducationLessThan(String value) {
            addCriterion("Education <", value, "education");
            return (Criteria) this;
        }

        public Criteria andEducationLessThanOrEqualTo(String value) {
            addCriterion("Education <=", value, "education");
            return (Criteria) this;
        }

        public Criteria andEducationLike(String value) {
            addCriterion("Education like", value, "education");
            return (Criteria) this;
        }

        public Criteria andEducationNotLike(String value) {
            addCriterion("Education not like", value, "education");
            return (Criteria) this;
        }

        public Criteria andEducationIn(List<String> values) {
            addCriterion("Education in", values, "education");
            return (Criteria) this;
        }

        public Criteria andEducationNotIn(List<String> values) {
            addCriterion("Education not in", values, "education");
            return (Criteria) this;
        }

        public Criteria andEducationBetween(String value1, String value2) {
            addCriterion("Education between", value1, value2, "education");
            return (Criteria) this;
        }

        public Criteria andEducationNotBetween(String value1, String value2) {
            addCriterion("Education not between", value1, value2, "education");
            return (Criteria) this;
        }

        public Criteria andPoliticsIsNull() {
            addCriterion("Politics is null");
            return (Criteria) this;
        }

        public Criteria andPoliticsIsNotNull() {
            addCriterion("Politics is not null");
            return (Criteria) this;
        }

        public Criteria andPoliticsEqualTo(String value) {
            addCriterion("Politics =", value, "politics");
            return (Criteria) this;
        }

        public Criteria andPoliticsNotEqualTo(String value) {
            addCriterion("Politics <>", value, "politics");
            return (Criteria) this;
        }

        public Criteria andPoliticsGreaterThan(String value) {
            addCriterion("Politics >", value, "politics");
            return (Criteria) this;
        }

        public Criteria andPoliticsGreaterThanOrEqualTo(String value) {
            addCriterion("Politics >=", value, "politics");
            return (Criteria) this;
        }

        public Criteria andPoliticsLessThan(String value) {
            addCriterion("Politics <", value, "politics");
            return (Criteria) this;
        }

        public Criteria andPoliticsLessThanOrEqualTo(String value) {
            addCriterion("Politics <=", value, "politics");
            return (Criteria) this;
        }

        public Criteria andPoliticsLike(String value) {
            addCriterion("Politics like", value, "politics");
            return (Criteria) this;
        }

        public Criteria andPoliticsNotLike(String value) {
            addCriterion("Politics not like", value, "politics");
            return (Criteria) this;
        }

        public Criteria andPoliticsIn(List<String> values) {
            addCriterion("Politics in", values, "politics");
            return (Criteria) this;
        }

        public Criteria andPoliticsNotIn(List<String> values) {
            addCriterion("Politics not in", values, "politics");
            return (Criteria) this;
        }

        public Criteria andPoliticsBetween(String value1, String value2) {
            addCriterion("Politics between", value1, value2, "politics");
            return (Criteria) this;
        }

        public Criteria andPoliticsNotBetween(String value1, String value2) {
            addCriterion("Politics not between", value1, value2, "politics");
            return (Criteria) this;
        }

        public Criteria andMarriageIsNull() {
            addCriterion("Marriage is null");
            return (Criteria) this;
        }

        public Criteria andMarriageIsNotNull() {
            addCriterion("Marriage is not null");
            return (Criteria) this;
        }

        public Criteria andMarriageEqualTo(String value) {
            addCriterion("Marriage =", value, "marriage");
            return (Criteria) this;
        }

        public Criteria andMarriageNotEqualTo(String value) {
            addCriterion("Marriage <>", value, "marriage");
            return (Criteria) this;
        }

        public Criteria andMarriageGreaterThan(String value) {
            addCriterion("Marriage >", value, "marriage");
            return (Criteria) this;
        }

        public Criteria andMarriageGreaterThanOrEqualTo(String value) {
            addCriterion("Marriage >=", value, "marriage");
            return (Criteria) this;
        }

        public Criteria andMarriageLessThan(String value) {
            addCriterion("Marriage <", value, "marriage");
            return (Criteria) this;
        }

        public Criteria andMarriageLessThanOrEqualTo(String value) {
            addCriterion("Marriage <=", value, "marriage");
            return (Criteria) this;
        }

        public Criteria andMarriageLike(String value) {
            addCriterion("Marriage like", value, "marriage");
            return (Criteria) this;
        }

        public Criteria andMarriageNotLike(String value) {
            addCriterion("Marriage not like", value, "marriage");
            return (Criteria) this;
        }

        public Criteria andMarriageIn(List<String> values) {
            addCriterion("Marriage in", values, "marriage");
            return (Criteria) this;
        }

        public Criteria andMarriageNotIn(List<String> values) {
            addCriterion("Marriage not in", values, "marriage");
            return (Criteria) this;
        }

        public Criteria andMarriageBetween(String value1, String value2) {
            addCriterion("Marriage between", value1, value2, "marriage");
            return (Criteria) this;
        }

        public Criteria andMarriageNotBetween(String value1, String value2) {
            addCriterion("Marriage not between", value1, value2, "marriage");
            return (Criteria) this;
        }

        public Criteria andAddressIsNull() {
            addCriterion("Address is null");
            return (Criteria) this;
        }

        public Criteria andAddressIsNotNull() {
            addCriterion("Address is not null");
            return (Criteria) this;
        }

        public Criteria andAddressEqualTo(String value) {
            addCriterion("Address =", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotEqualTo(String value) {
            addCriterion("Address <>", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressGreaterThan(String value) {
            addCriterion("Address >", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressGreaterThanOrEqualTo(String value) {
            addCriterion("Address >=", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressLessThan(String value) {
            addCriterion("Address <", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressLessThanOrEqualTo(String value) {
            addCriterion("Address <=", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressLike(String value) {
            addCriterion("Address like", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotLike(String value) {
            addCriterion("Address not like", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressIn(List<String> values) {
            addCriterion("Address in", values, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotIn(List<String> values) {
            addCriterion("Address not in", values, "address");
            return (Criteria) this;
        }

        public Criteria andAddressBetween(String value1, String value2) {
            addCriterion("Address between", value1, value2, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotBetween(String value1, String value2) {
            addCriterion("Address not between", value1, value2, "address");
            return (Criteria) this;
        }

        public Criteria andHometelIsNull() {
            addCriterion("HomeTel is null");
            return (Criteria) this;
        }

        public Criteria andHometelIsNotNull() {
            addCriterion("HomeTel is not null");
            return (Criteria) this;
        }

        public Criteria andHometelEqualTo(String value) {
            addCriterion("HomeTel =", value, "hometel");
            return (Criteria) this;
        }

        public Criteria andHometelNotEqualTo(String value) {
            addCriterion("HomeTel <>", value, "hometel");
            return (Criteria) this;
        }

        public Criteria andHometelGreaterThan(String value) {
            addCriterion("HomeTel >", value, "hometel");
            return (Criteria) this;
        }

        public Criteria andHometelGreaterThanOrEqualTo(String value) {
            addCriterion("HomeTel >=", value, "hometel");
            return (Criteria) this;
        }

        public Criteria andHometelLessThan(String value) {
            addCriterion("HomeTel <", value, "hometel");
            return (Criteria) this;
        }

        public Criteria andHometelLessThanOrEqualTo(String value) {
            addCriterion("HomeTel <=", value, "hometel");
            return (Criteria) this;
        }

        public Criteria andHometelLike(String value) {
            addCriterion("HomeTel like", value, "hometel");
            return (Criteria) this;
        }

        public Criteria andHometelNotLike(String value) {
            addCriterion("HomeTel not like", value, "hometel");
            return (Criteria) this;
        }

        public Criteria andHometelIn(List<String> values) {
            addCriterion("HomeTel in", values, "hometel");
            return (Criteria) this;
        }

        public Criteria andHometelNotIn(List<String> values) {
            addCriterion("HomeTel not in", values, "hometel");
            return (Criteria) this;
        }

        public Criteria andHometelBetween(String value1, String value2) {
            addCriterion("HomeTel between", value1, value2, "hometel");
            return (Criteria) this;
        }

        public Criteria andHometelNotBetween(String value1, String value2) {
            addCriterion("HomeTel not between", value1, value2, "hometel");
            return (Criteria) this;
        }

        public Criteria andMobtelIsNull() {
            addCriterion("MobTel is null");
            return (Criteria) this;
        }

        public Criteria andMobtelIsNotNull() {
            addCriterion("MobTel is not null");
            return (Criteria) this;
        }

        public Criteria andMobtelEqualTo(String value) {
            addCriterion("MobTel =", value, "mobtel");
            return (Criteria) this;
        }

        public Criteria andMobtelNotEqualTo(String value) {
            addCriterion("MobTel <>", value, "mobtel");
            return (Criteria) this;
        }

        public Criteria andMobtelGreaterThan(String value) {
            addCriterion("MobTel >", value, "mobtel");
            return (Criteria) this;
        }

        public Criteria andMobtelGreaterThanOrEqualTo(String value) {
            addCriterion("MobTel >=", value, "mobtel");
            return (Criteria) this;
        }

        public Criteria andMobtelLessThan(String value) {
            addCriterion("MobTel <", value, "mobtel");
            return (Criteria) this;
        }

        public Criteria andMobtelLessThanOrEqualTo(String value) {
            addCriterion("MobTel <=", value, "mobtel");
            return (Criteria) this;
        }

        public Criteria andMobtelLike(String value) {
            addCriterion("MobTel like", value, "mobtel");
            return (Criteria) this;
        }

        public Criteria andMobtelNotLike(String value) {
            addCriterion("MobTel not like", value, "mobtel");
            return (Criteria) this;
        }

        public Criteria andMobtelIn(List<String> values) {
            addCriterion("MobTel in", values, "mobtel");
            return (Criteria) this;
        }

        public Criteria andMobtelNotIn(List<String> values) {
            addCriterion("MobTel not in", values, "mobtel");
            return (Criteria) this;
        }

        public Criteria andMobtelBetween(String value1, String value2) {
            addCriterion("MobTel between", value1, value2, "mobtel");
            return (Criteria) this;
        }

        public Criteria andMobtelNotBetween(String value1, String value2) {
            addCriterion("MobTel not between", value1, value2, "mobtel");
            return (Criteria) this;
        }

        public Criteria andEmailIsNull() {
            addCriterion("Email is null");
            return (Criteria) this;
        }

        public Criteria andEmailIsNotNull() {
            addCriterion("Email is not null");
            return (Criteria) this;
        }

        public Criteria andEmailEqualTo(String value) {
            addCriterion("Email =", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailNotEqualTo(String value) {
            addCriterion("Email <>", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailGreaterThan(String value) {
            addCriterion("Email >", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailGreaterThanOrEqualTo(String value) {
            addCriterion("Email >=", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailLessThan(String value) {
            addCriterion("Email <", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailLessThanOrEqualTo(String value) {
            addCriterion("Email <=", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailLike(String value) {
            addCriterion("Email like", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailNotLike(String value) {
            addCriterion("Email not like", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailIn(List<String> values) {
            addCriterion("Email in", values, "email");
            return (Criteria) this;
        }

        public Criteria andEmailNotIn(List<String> values) {
            addCriterion("Email not in", values, "email");
            return (Criteria) this;
        }

        public Criteria andEmailBetween(String value1, String value2) {
            addCriterion("Email between", value1, value2, "email");
            return (Criteria) this;
        }

        public Criteria andEmailNotBetween(String value1, String value2) {
            addCriterion("Email not between", value1, value2, "email");
            return (Criteria) this;
        }

        public Criteria andPostnoIsNull() {
            addCriterion("PostNo is null");
            return (Criteria) this;
        }

        public Criteria andPostnoIsNotNull() {
            addCriterion("PostNo is not null");
            return (Criteria) this;
        }

        public Criteria andPostnoEqualTo(String value) {
            addCriterion("PostNo =", value, "postno");
            return (Criteria) this;
        }

        public Criteria andPostnoNotEqualTo(String value) {
            addCriterion("PostNo <>", value, "postno");
            return (Criteria) this;
        }

        public Criteria andPostnoGreaterThan(String value) {
            addCriterion("PostNo >", value, "postno");
            return (Criteria) this;
        }

        public Criteria andPostnoGreaterThanOrEqualTo(String value) {
            addCriterion("PostNo >=", value, "postno");
            return (Criteria) this;
        }

        public Criteria andPostnoLessThan(String value) {
            addCriterion("PostNo <", value, "postno");
            return (Criteria) this;
        }

        public Criteria andPostnoLessThanOrEqualTo(String value) {
            addCriterion("PostNo <=", value, "postno");
            return (Criteria) this;
        }

        public Criteria andPostnoLike(String value) {
            addCriterion("PostNo like", value, "postno");
            return (Criteria) this;
        }

        public Criteria andPostnoNotLike(String value) {
            addCriterion("PostNo not like", value, "postno");
            return (Criteria) this;
        }

        public Criteria andPostnoIn(List<String> values) {
            addCriterion("PostNo in", values, "postno");
            return (Criteria) this;
        }

        public Criteria andPostnoNotIn(List<String> values) {
            addCriterion("PostNo not in", values, "postno");
            return (Criteria) this;
        }

        public Criteria andPostnoBetween(String value1, String value2) {
            addCriterion("PostNo between", value1, value2, "postno");
            return (Criteria) this;
        }

        public Criteria andPostnoNotBetween(String value1, String value2) {
            addCriterion("PostNo not between", value1, value2, "postno");
            return (Criteria) this;
        }

        public Criteria andTaxnoIsNull() {
            addCriterion("TaxNo is null");
            return (Criteria) this;
        }

        public Criteria andTaxnoIsNotNull() {
            addCriterion("TaxNo is not null");
            return (Criteria) this;
        }

        public Criteria andTaxnoEqualTo(String value) {
            addCriterion("TaxNo =", value, "taxno");
            return (Criteria) this;
        }

        public Criteria andTaxnoNotEqualTo(String value) {
            addCriterion("TaxNo <>", value, "taxno");
            return (Criteria) this;
        }

        public Criteria andTaxnoGreaterThan(String value) {
            addCriterion("TaxNo >", value, "taxno");
            return (Criteria) this;
        }

        public Criteria andTaxnoGreaterThanOrEqualTo(String value) {
            addCriterion("TaxNo >=", value, "taxno");
            return (Criteria) this;
        }

        public Criteria andTaxnoLessThan(String value) {
            addCriterion("TaxNo <", value, "taxno");
            return (Criteria) this;
        }

        public Criteria andTaxnoLessThanOrEqualTo(String value) {
            addCriterion("TaxNo <=", value, "taxno");
            return (Criteria) this;
        }

        public Criteria andTaxnoLike(String value) {
            addCriterion("TaxNo like", value, "taxno");
            return (Criteria) this;
        }

        public Criteria andTaxnoNotLike(String value) {
            addCriterion("TaxNo not like", value, "taxno");
            return (Criteria) this;
        }

        public Criteria andTaxnoIn(List<String> values) {
            addCriterion("TaxNo in", values, "taxno");
            return (Criteria) this;
        }

        public Criteria andTaxnoNotIn(List<String> values) {
            addCriterion("TaxNo not in", values, "taxno");
            return (Criteria) this;
        }

        public Criteria andTaxnoBetween(String value1, String value2) {
            addCriterion("TaxNo between", value1, value2, "taxno");
            return (Criteria) this;
        }

        public Criteria andTaxnoNotBetween(String value1, String value2) {
            addCriterion("TaxNo not between", value1, value2, "taxno");
            return (Criteria) this;
        }

        public Criteria andStorecodeIsNull() {
            addCriterion("StoreCode is null");
            return (Criteria) this;
        }

        public Criteria andStorecodeIsNotNull() {
            addCriterion("StoreCode is not null");
            return (Criteria) this;
        }

        public Criteria andStorecodeEqualTo(String value) {
            addCriterion("StoreCode =", value, "storecode");
            return (Criteria) this;
        }

        public Criteria andStorecodeNotEqualTo(String value) {
            addCriterion("StoreCode <>", value, "storecode");
            return (Criteria) this;
        }

        public Criteria andStorecodeGreaterThan(String value) {
            addCriterion("StoreCode >", value, "storecode");
            return (Criteria) this;
        }

        public Criteria andStorecodeGreaterThanOrEqualTo(String value) {
            addCriterion("StoreCode >=", value, "storecode");
            return (Criteria) this;
        }

        public Criteria andStorecodeLessThan(String value) {
            addCriterion("StoreCode <", value, "storecode");
            return (Criteria) this;
        }

        public Criteria andStorecodeLessThanOrEqualTo(String value) {
            addCriterion("StoreCode <=", value, "storecode");
            return (Criteria) this;
        }

        public Criteria andStorecodeLike(String value) {
            addCriterion("StoreCode like", value, "storecode");
            return (Criteria) this;
        }

        public Criteria andStorecodeNotLike(String value) {
            addCriterion("StoreCode not like", value, "storecode");
            return (Criteria) this;
        }

        public Criteria andStorecodeIn(List<String> values) {
            addCriterion("StoreCode in", values, "storecode");
            return (Criteria) this;
        }

        public Criteria andStorecodeNotIn(List<String> values) {
            addCriterion("StoreCode not in", values, "storecode");
            return (Criteria) this;
        }

        public Criteria andStorecodeBetween(String value1, String value2) {
            addCriterion("StoreCode between", value1, value2, "storecode");
            return (Criteria) this;
        }

        public Criteria andStorecodeNotBetween(String value1, String value2) {
            addCriterion("StoreCode not between", value1, value2, "storecode");
            return (Criteria) this;
        }

        public Criteria andLastshoptimeIsNull() {
            addCriterion("LastShopTime is null");
            return (Criteria) this;
        }

        public Criteria andLastshoptimeIsNotNull() {
            addCriterion("LastShopTime is not null");
            return (Criteria) this;
        }

        public Criteria andLastshoptimeEqualTo(Date value) {
            addCriterion("LastShopTime =", value, "lastshoptime");
            return (Criteria) this;
        }

        public Criteria andLastshoptimeNotEqualTo(Date value) {
            addCriterion("LastShopTime <>", value, "lastshoptime");
            return (Criteria) this;
        }

        public Criteria andLastshoptimeGreaterThan(Date value) {
            addCriterion("LastShopTime >", value, "lastshoptime");
            return (Criteria) this;
        }

        public Criteria andLastshoptimeGreaterThanOrEqualTo(Date value) {
            addCriterion("LastShopTime >=", value, "lastshoptime");
            return (Criteria) this;
        }

        public Criteria andLastshoptimeLessThan(Date value) {
            addCriterion("LastShopTime <", value, "lastshoptime");
            return (Criteria) this;
        }

        public Criteria andLastshoptimeLessThanOrEqualTo(Date value) {
            addCriterion("LastShopTime <=", value, "lastshoptime");
            return (Criteria) this;
        }

        public Criteria andLastshoptimeIn(List<Date> values) {
            addCriterion("LastShopTime in", values, "lastshoptime");
            return (Criteria) this;
        }

        public Criteria andLastshoptimeNotIn(List<Date> values) {
            addCriterion("LastShopTime not in", values, "lastshoptime");
            return (Criteria) this;
        }

        public Criteria andLastshoptimeBetween(Date value1, Date value2) {
            addCriterion("LastShopTime between", value1, value2, "lastshoptime");
            return (Criteria) this;
        }

        public Criteria andLastshoptimeNotBetween(Date value1, Date value2) {
            addCriterion("LastShopTime not between", value1, value2, "lastshoptime");
            return (Criteria) this;
        }

        public Criteria andMaxbillamtIsNull() {
            addCriterion("MaxBillAmt is null");
            return (Criteria) this;
        }

        public Criteria andMaxbillamtIsNotNull() {
            addCriterion("MaxBillAmt is not null");
            return (Criteria) this;
        }

        public Criteria andMaxbillamtEqualTo(BigDecimal value) {
            addCriterion("MaxBillAmt =", value, "maxbillamt");
            return (Criteria) this;
        }

        public Criteria andMaxbillamtNotEqualTo(BigDecimal value) {
            addCriterion("MaxBillAmt <>", value, "maxbillamt");
            return (Criteria) this;
        }

        public Criteria andMaxbillamtGreaterThan(BigDecimal value) {
            addCriterion("MaxBillAmt >", value, "maxbillamt");
            return (Criteria) this;
        }

        public Criteria andMaxbillamtGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("MaxBillAmt >=", value, "maxbillamt");
            return (Criteria) this;
        }

        public Criteria andMaxbillamtLessThan(BigDecimal value) {
            addCriterion("MaxBillAmt <", value, "maxbillamt");
            return (Criteria) this;
        }

        public Criteria andMaxbillamtLessThanOrEqualTo(BigDecimal value) {
            addCriterion("MaxBillAmt <=", value, "maxbillamt");
            return (Criteria) this;
        }

        public Criteria andMaxbillamtIn(List<BigDecimal> values) {
            addCriterion("MaxBillAmt in", values, "maxbillamt");
            return (Criteria) this;
        }

        public Criteria andMaxbillamtNotIn(List<BigDecimal> values) {
            addCriterion("MaxBillAmt not in", values, "maxbillamt");
            return (Criteria) this;
        }

        public Criteria andMaxbillamtBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("MaxBillAmt between", value1, value2, "maxbillamt");
            return (Criteria) this;
        }

        public Criteria andMaxbillamtNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("MaxBillAmt not between", value1, value2, "maxbillamt");
            return (Criteria) this;
        }

        public Criteria andShoppingtimesIsNull() {
            addCriterion("ShoppingTimes is null");
            return (Criteria) this;
        }

        public Criteria andShoppingtimesIsNotNull() {
            addCriterion("ShoppingTimes is not null");
            return (Criteria) this;
        }

        public Criteria andShoppingtimesEqualTo(Integer value) {
            addCriterion("ShoppingTimes =", value, "shoppingtimes");
            return (Criteria) this;
        }

        public Criteria andShoppingtimesNotEqualTo(Integer value) {
            addCriterion("ShoppingTimes <>", value, "shoppingtimes");
            return (Criteria) this;
        }

        public Criteria andShoppingtimesGreaterThan(Integer value) {
            addCriterion("ShoppingTimes >", value, "shoppingtimes");
            return (Criteria) this;
        }

        public Criteria andShoppingtimesGreaterThanOrEqualTo(Integer value) {
            addCriterion("ShoppingTimes >=", value, "shoppingtimes");
            return (Criteria) this;
        }

        public Criteria andShoppingtimesLessThan(Integer value) {
            addCriterion("ShoppingTimes <", value, "shoppingtimes");
            return (Criteria) this;
        }

        public Criteria andShoppingtimesLessThanOrEqualTo(Integer value) {
            addCriterion("ShoppingTimes <=", value, "shoppingtimes");
            return (Criteria) this;
        }

        public Criteria andShoppingtimesIn(List<Integer> values) {
            addCriterion("ShoppingTimes in", values, "shoppingtimes");
            return (Criteria) this;
        }

        public Criteria andShoppingtimesNotIn(List<Integer> values) {
            addCriterion("ShoppingTimes not in", values, "shoppingtimes");
            return (Criteria) this;
        }

        public Criteria andShoppingtimesBetween(Integer value1, Integer value2) {
            addCriterion("ShoppingTimes between", value1, value2, "shoppingtimes");
            return (Criteria) this;
        }

        public Criteria andShoppingtimesNotBetween(Integer value1, Integer value2) {
            addCriterion("ShoppingTimes not between", value1, value2, "shoppingtimes");
            return (Criteria) this;
        }

        public Criteria andTotalsaleIsNull() {
            addCriterion("TotalSale is null");
            return (Criteria) this;
        }

        public Criteria andTotalsaleIsNotNull() {
            addCriterion("TotalSale is not null");
            return (Criteria) this;
        }

        public Criteria andTotalsaleEqualTo(BigDecimal value) {
            addCriterion("TotalSale =", value, "totalsale");
            return (Criteria) this;
        }

        public Criteria andTotalsaleNotEqualTo(BigDecimal value) {
            addCriterion("TotalSale <>", value, "totalsale");
            return (Criteria) this;
        }

        public Criteria andTotalsaleGreaterThan(BigDecimal value) {
            addCriterion("TotalSale >", value, "totalsale");
            return (Criteria) this;
        }

        public Criteria andTotalsaleGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("TotalSale >=", value, "totalsale");
            return (Criteria) this;
        }

        public Criteria andTotalsaleLessThan(BigDecimal value) {
            addCriterion("TotalSale <", value, "totalsale");
            return (Criteria) this;
        }

        public Criteria andTotalsaleLessThanOrEqualTo(BigDecimal value) {
            addCriterion("TotalSale <=", value, "totalsale");
            return (Criteria) this;
        }

        public Criteria andTotalsaleIn(List<BigDecimal> values) {
            addCriterion("TotalSale in", values, "totalsale");
            return (Criteria) this;
        }

        public Criteria andTotalsaleNotIn(List<BigDecimal> values) {
            addCriterion("TotalSale not in", values, "totalsale");
            return (Criteria) this;
        }

        public Criteria andTotalsaleBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("TotalSale between", value1, value2, "totalsale");
            return (Criteria) this;
        }

        public Criteria andTotalsaleNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("TotalSale not between", value1, value2, "totalsale");
            return (Criteria) this;
        }

        public Criteria andSalebalanceIsNull() {
            addCriterion("SaleBalance is null");
            return (Criteria) this;
        }

        public Criteria andSalebalanceIsNotNull() {
            addCriterion("SaleBalance is not null");
            return (Criteria) this;
        }

        public Criteria andSalebalanceEqualTo(BigDecimal value) {
            addCriterion("SaleBalance =", value, "salebalance");
            return (Criteria) this;
        }

        public Criteria andSalebalanceNotEqualTo(BigDecimal value) {
            addCriterion("SaleBalance <>", value, "salebalance");
            return (Criteria) this;
        }

        public Criteria andSalebalanceGreaterThan(BigDecimal value) {
            addCriterion("SaleBalance >", value, "salebalance");
            return (Criteria) this;
        }

        public Criteria andSalebalanceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("SaleBalance >=", value, "salebalance");
            return (Criteria) this;
        }

        public Criteria andSalebalanceLessThan(BigDecimal value) {
            addCriterion("SaleBalance <", value, "salebalance");
            return (Criteria) this;
        }

        public Criteria andSalebalanceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("SaleBalance <=", value, "salebalance");
            return (Criteria) this;
        }

        public Criteria andSalebalanceIn(List<BigDecimal> values) {
            addCriterion("SaleBalance in", values, "salebalance");
            return (Criteria) this;
        }

        public Criteria andSalebalanceNotIn(List<BigDecimal> values) {
            addCriterion("SaleBalance not in", values, "salebalance");
            return (Criteria) this;
        }

        public Criteria andSalebalanceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("SaleBalance between", value1, value2, "salebalance");
            return (Criteria) this;
        }

        public Criteria andSalebalanceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("SaleBalance not between", value1, value2, "salebalance");
            return (Criteria) this;
        }

        public Criteria andSalebalancedIsNull() {
            addCriterion("SaleBalanced is null");
            return (Criteria) this;
        }

        public Criteria andSalebalancedIsNotNull() {
            addCriterion("SaleBalanced is not null");
            return (Criteria) this;
        }

        public Criteria andSalebalancedEqualTo(BigDecimal value) {
            addCriterion("SaleBalanced =", value, "salebalanced");
            return (Criteria) this;
        }

        public Criteria andSalebalancedNotEqualTo(BigDecimal value) {
            addCriterion("SaleBalanced <>", value, "salebalanced");
            return (Criteria) this;
        }

        public Criteria andSalebalancedGreaterThan(BigDecimal value) {
            addCriterion("SaleBalanced >", value, "salebalanced");
            return (Criteria) this;
        }

        public Criteria andSalebalancedGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("SaleBalanced >=", value, "salebalanced");
            return (Criteria) this;
        }

        public Criteria andSalebalancedLessThan(BigDecimal value) {
            addCriterion("SaleBalanced <", value, "salebalanced");
            return (Criteria) this;
        }

        public Criteria andSalebalancedLessThanOrEqualTo(BigDecimal value) {
            addCriterion("SaleBalanced <=", value, "salebalanced");
            return (Criteria) this;
        }

        public Criteria andSalebalancedIn(List<BigDecimal> values) {
            addCriterion("SaleBalanced in", values, "salebalanced");
            return (Criteria) this;
        }

        public Criteria andSalebalancedNotIn(List<BigDecimal> values) {
            addCriterion("SaleBalanced not in", values, "salebalanced");
            return (Criteria) this;
        }

        public Criteria andSalebalancedBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("SaleBalanced between", value1, value2, "salebalanced");
            return (Criteria) this;
        }

        public Criteria andSalebalancedNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("SaleBalanced not between", value1, value2, "salebalanced");
            return (Criteria) this;
        }

        public Criteria andTotalpointIsNull() {
            addCriterion("TotalPoint is null");
            return (Criteria) this;
        }

        public Criteria andTotalpointIsNotNull() {
            addCriterion("TotalPoint is not null");
            return (Criteria) this;
        }

        public Criteria andTotalpointEqualTo(BigDecimal value) {
            addCriterion("TotalPoint =", value, "totalpoint");
            return (Criteria) this;
        }

        public Criteria andTotalpointNotEqualTo(BigDecimal value) {
            addCriterion("TotalPoint <>", value, "totalpoint");
            return (Criteria) this;
        }

        public Criteria andTotalpointGreaterThan(BigDecimal value) {
            addCriterion("TotalPoint >", value, "totalpoint");
            return (Criteria) this;
        }

        public Criteria andTotalpointGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("TotalPoint >=", value, "totalpoint");
            return (Criteria) this;
        }

        public Criteria andTotalpointLessThan(BigDecimal value) {
            addCriterion("TotalPoint <", value, "totalpoint");
            return (Criteria) this;
        }

        public Criteria andTotalpointLessThanOrEqualTo(BigDecimal value) {
            addCriterion("TotalPoint <=", value, "totalpoint");
            return (Criteria) this;
        }

        public Criteria andTotalpointIn(List<BigDecimal> values) {
            addCriterion("TotalPoint in", values, "totalpoint");
            return (Criteria) this;
        }

        public Criteria andTotalpointNotIn(List<BigDecimal> values) {
            addCriterion("TotalPoint not in", values, "totalpoint");
            return (Criteria) this;
        }

        public Criteria andTotalpointBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("TotalPoint between", value1, value2, "totalpoint");
            return (Criteria) this;
        }

        public Criteria andTotalpointNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("TotalPoint not between", value1, value2, "totalpoint");
            return (Criteria) this;
        }

        public Criteria andIssuedateIsNull() {
            addCriterion("IssueDate is null");
            return (Criteria) this;
        }

        public Criteria andIssuedateIsNotNull() {
            addCriterion("IssueDate is not null");
            return (Criteria) this;
        }

        public Criteria andIssuedateEqualTo(Date value) {
            addCriterion("IssueDate =", value, "issuedate");
            return (Criteria) this;
        }

        public Criteria andIssuedateNotEqualTo(Date value) {
            addCriterion("IssueDate <>", value, "issuedate");
            return (Criteria) this;
        }

        public Criteria andIssuedateGreaterThan(Date value) {
            addCriterion("IssueDate >", value, "issuedate");
            return (Criteria) this;
        }

        public Criteria andIssuedateGreaterThanOrEqualTo(Date value) {
            addCriterion("IssueDate >=", value, "issuedate");
            return (Criteria) this;
        }

        public Criteria andIssuedateLessThan(Date value) {
            addCriterion("IssueDate <", value, "issuedate");
            return (Criteria) this;
        }

        public Criteria andIssuedateLessThanOrEqualTo(Date value) {
            addCriterion("IssueDate <=", value, "issuedate");
            return (Criteria) this;
        }

        public Criteria andIssuedateIn(List<Date> values) {
            addCriterion("IssueDate in", values, "issuedate");
            return (Criteria) this;
        }

        public Criteria andIssuedateNotIn(List<Date> values) {
            addCriterion("IssueDate not in", values, "issuedate");
            return (Criteria) this;
        }

        public Criteria andIssuedateBetween(Date value1, Date value2) {
            addCriterion("IssueDate between", value1, value2, "issuedate");
            return (Criteria) this;
        }

        public Criteria andIssuedateNotBetween(Date value1, Date value2) {
            addCriterion("IssueDate not between", value1, value2, "issuedate");
            return (Criteria) this;
        }

        public Criteria andIssuerIsNull() {
            addCriterion("Issuer is null");
            return (Criteria) this;
        }

        public Criteria andIssuerIsNotNull() {
            addCriterion("Issuer is not null");
            return (Criteria) this;
        }

        public Criteria andIssuerEqualTo(String value) {
            addCriterion("Issuer =", value, "issuer");
            return (Criteria) this;
        }

        public Criteria andIssuerNotEqualTo(String value) {
            addCriterion("Issuer <>", value, "issuer");
            return (Criteria) this;
        }

        public Criteria andIssuerGreaterThan(String value) {
            addCriterion("Issuer >", value, "issuer");
            return (Criteria) this;
        }

        public Criteria andIssuerGreaterThanOrEqualTo(String value) {
            addCriterion("Issuer >=", value, "issuer");
            return (Criteria) this;
        }

        public Criteria andIssuerLessThan(String value) {
            addCriterion("Issuer <", value, "issuer");
            return (Criteria) this;
        }

        public Criteria andIssuerLessThanOrEqualTo(String value) {
            addCriterion("Issuer <=", value, "issuer");
            return (Criteria) this;
        }

        public Criteria andIssuerLike(String value) {
            addCriterion("Issuer like", value, "issuer");
            return (Criteria) this;
        }

        public Criteria andIssuerNotLike(String value) {
            addCriterion("Issuer not like", value, "issuer");
            return (Criteria) this;
        }

        public Criteria andIssuerIn(List<String> values) {
            addCriterion("Issuer in", values, "issuer");
            return (Criteria) this;
        }

        public Criteria andIssuerNotIn(List<String> values) {
            addCriterion("Issuer not in", values, "issuer");
            return (Criteria) this;
        }

        public Criteria andIssuerBetween(String value1, String value2) {
            addCriterion("Issuer between", value1, value2, "issuer");
            return (Criteria) this;
        }

        public Criteria andIssuerNotBetween(String value1, String value2) {
            addCriterion("Issuer not between", value1, value2, "issuer");
            return (Criteria) this;
        }

        public Criteria andValidatedateIsNull() {
            addCriterion("ValidateDate is null");
            return (Criteria) this;
        }

        public Criteria andValidatedateIsNotNull() {
            addCriterion("ValidateDate is not null");
            return (Criteria) this;
        }

        public Criteria andValidatedateEqualTo(Date value) {
            addCriterion("ValidateDate =", value, "validatedate");
            return (Criteria) this;
        }

        public Criteria andValidatedateNotEqualTo(Date value) {
            addCriterion("ValidateDate <>", value, "validatedate");
            return (Criteria) this;
        }

        public Criteria andValidatedateGreaterThan(Date value) {
            addCriterion("ValidateDate >", value, "validatedate");
            return (Criteria) this;
        }

        public Criteria andValidatedateGreaterThanOrEqualTo(Date value) {
            addCriterion("ValidateDate >=", value, "validatedate");
            return (Criteria) this;
        }

        public Criteria andValidatedateLessThan(Date value) {
            addCriterion("ValidateDate <", value, "validatedate");
            return (Criteria) this;
        }

        public Criteria andValidatedateLessThanOrEqualTo(Date value) {
            addCriterion("ValidateDate <=", value, "validatedate");
            return (Criteria) this;
        }

        public Criteria andValidatedateIn(List<Date> values) {
            addCriterion("ValidateDate in", values, "validatedate");
            return (Criteria) this;
        }

        public Criteria andValidatedateNotIn(List<Date> values) {
            addCriterion("ValidateDate not in", values, "validatedate");
            return (Criteria) this;
        }

        public Criteria andValidatedateBetween(Date value1, Date value2) {
            addCriterion("ValidateDate between", value1, value2, "validatedate");
            return (Criteria) this;
        }

        public Criteria andValidatedateNotBetween(Date value1, Date value2) {
            addCriterion("ValidateDate not between", value1, value2, "validatedate");
            return (Criteria) this;
        }

        public Criteria andCardstatusIsNull() {
            addCriterion("CardStatus is null");
            return (Criteria) this;
        }

        public Criteria andCardstatusIsNotNull() {
            addCriterion("CardStatus is not null");
            return (Criteria) this;
        }

        public Criteria andCardstatusEqualTo(String value) {
            addCriterion("CardStatus =", value, "cardstatus");
            return (Criteria) this;
        }

        public Criteria andCardstatusNotEqualTo(String value) {
            addCriterion("CardStatus <>", value, "cardstatus");
            return (Criteria) this;
        }

        public Criteria andCardstatusGreaterThan(String value) {
            addCriterion("CardStatus >", value, "cardstatus");
            return (Criteria) this;
        }

        public Criteria andCardstatusGreaterThanOrEqualTo(String value) {
            addCriterion("CardStatus >=", value, "cardstatus");
            return (Criteria) this;
        }

        public Criteria andCardstatusLessThan(String value) {
            addCriterion("CardStatus <", value, "cardstatus");
            return (Criteria) this;
        }

        public Criteria andCardstatusLessThanOrEqualTo(String value) {
            addCriterion("CardStatus <=", value, "cardstatus");
            return (Criteria) this;
        }

        public Criteria andCardstatusLike(String value) {
            addCriterion("CardStatus like", value, "cardstatus");
            return (Criteria) this;
        }

        public Criteria andCardstatusNotLike(String value) {
            addCriterion("CardStatus not like", value, "cardstatus");
            return (Criteria) this;
        }

        public Criteria andCardstatusIn(List<String> values) {
            addCriterion("CardStatus in", values, "cardstatus");
            return (Criteria) this;
        }

        public Criteria andCardstatusNotIn(List<String> values) {
            addCriterion("CardStatus not in", values, "cardstatus");
            return (Criteria) this;
        }

        public Criteria andCardstatusBetween(String value1, String value2) {
            addCriterion("CardStatus between", value1, value2, "cardstatus");
            return (Criteria) this;
        }

        public Criteria andCardstatusNotBetween(String value1, String value2) {
            addCriterion("CardStatus not between", value1, value2, "cardstatus");
            return (Criteria) this;
        }

        public Criteria andNewcardnoIsNull() {
            addCriterion("NewCardNo is null");
            return (Criteria) this;
        }

        public Criteria andNewcardnoIsNotNull() {
            addCriterion("NewCardNo is not null");
            return (Criteria) this;
        }

        public Criteria andNewcardnoEqualTo(String value) {
            addCriterion("NewCardNo =", value, "newcardno");
            return (Criteria) this;
        }

        public Criteria andNewcardnoNotEqualTo(String value) {
            addCriterion("NewCardNo <>", value, "newcardno");
            return (Criteria) this;
        }

        public Criteria andNewcardnoGreaterThan(String value) {
            addCriterion("NewCardNo >", value, "newcardno");
            return (Criteria) this;
        }

        public Criteria andNewcardnoGreaterThanOrEqualTo(String value) {
            addCriterion("NewCardNo >=", value, "newcardno");
            return (Criteria) this;
        }

        public Criteria andNewcardnoLessThan(String value) {
            addCriterion("NewCardNo <", value, "newcardno");
            return (Criteria) this;
        }

        public Criteria andNewcardnoLessThanOrEqualTo(String value) {
            addCriterion("NewCardNo <=", value, "newcardno");
            return (Criteria) this;
        }

        public Criteria andNewcardnoLike(String value) {
            addCriterion("NewCardNo like", value, "newcardno");
            return (Criteria) this;
        }

        public Criteria andNewcardnoNotLike(String value) {
            addCriterion("NewCardNo not like", value, "newcardno");
            return (Criteria) this;
        }

        public Criteria andNewcardnoIn(List<String> values) {
            addCriterion("NewCardNo in", values, "newcardno");
            return (Criteria) this;
        }

        public Criteria andNewcardnoNotIn(List<String> values) {
            addCriterion("NewCardNo not in", values, "newcardno");
            return (Criteria) this;
        }

        public Criteria andNewcardnoBetween(String value1, String value2) {
            addCriterion("NewCardNo between", value1, value2, "newcardno");
            return (Criteria) this;
        }

        public Criteria andNewcardnoNotBetween(String value1, String value2) {
            addCriterion("NewCardNo not between", value1, value2, "newcardno");
            return (Criteria) this;
        }

        public Criteria andRemarkIsNull() {
            addCriterion("Remark is null");
            return (Criteria) this;
        }

        public Criteria andRemarkIsNotNull() {
            addCriterion("Remark is not null");
            return (Criteria) this;
        }

        public Criteria andRemarkEqualTo(String value) {
            addCriterion("Remark =", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotEqualTo(String value) {
            addCriterion("Remark <>", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkGreaterThan(String value) {
            addCriterion("Remark >", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkGreaterThanOrEqualTo(String value) {
            addCriterion("Remark >=", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLessThan(String value) {
            addCriterion("Remark <", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLessThanOrEqualTo(String value) {
            addCriterion("Remark <=", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLike(String value) {
            addCriterion("Remark like", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotLike(String value) {
            addCriterion("Remark not like", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkIn(List<String> values) {
            addCriterion("Remark in", values, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotIn(List<String> values) {
            addCriterion("Remark not in", values, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkBetween(String value1, String value2) {
            addCriterion("Remark between", value1, value2, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotBetween(String value1, String value2) {
            addCriterion("Remark not between", value1, value2, "remark");
            return (Criteria) this;
        }

        public Criteria andVipclassIsNull() {
            addCriterion("VipClass is null");
            return (Criteria) this;
        }

        public Criteria andVipclassIsNotNull() {
            addCriterion("VipClass is not null");
            return (Criteria) this;
        }

        public Criteria andVipclassEqualTo(String value) {
            addCriterion("VipClass =", value, "vipclass");
            return (Criteria) this;
        }

        public Criteria andVipclassNotEqualTo(String value) {
            addCriterion("VipClass <>", value, "vipclass");
            return (Criteria) this;
        }

        public Criteria andVipclassGreaterThan(String value) {
            addCriterion("VipClass >", value, "vipclass");
            return (Criteria) this;
        }

        public Criteria andVipclassGreaterThanOrEqualTo(String value) {
            addCriterion("VipClass >=", value, "vipclass");
            return (Criteria) this;
        }

        public Criteria andVipclassLessThan(String value) {
            addCriterion("VipClass <", value, "vipclass");
            return (Criteria) this;
        }

        public Criteria andVipclassLessThanOrEqualTo(String value) {
            addCriterion("VipClass <=", value, "vipclass");
            return (Criteria) this;
        }

        public Criteria andVipclassLike(String value) {
            addCriterion("VipClass like", value, "vipclass");
            return (Criteria) this;
        }

        public Criteria andVipclassNotLike(String value) {
            addCriterion("VipClass not like", value, "vipclass");
            return (Criteria) this;
        }

        public Criteria andVipclassIn(List<String> values) {
            addCriterion("VipClass in", values, "vipclass");
            return (Criteria) this;
        }

        public Criteria andVipclassNotIn(List<String> values) {
            addCriterion("VipClass not in", values, "vipclass");
            return (Criteria) this;
        }

        public Criteria andVipclassBetween(String value1, String value2) {
            addCriterion("VipClass between", value1, value2, "vipclass");
            return (Criteria) this;
        }

        public Criteria andVipclassNotBetween(String value1, String value2) {
            addCriterion("VipClass not between", value1, value2, "vipclass");
            return (Criteria) this;
        }

        public Criteria andNewupdateIsNull() {
            addCriterion("NewUpdate is null");
            return (Criteria) this;
        }

        public Criteria andNewupdateIsNotNull() {
            addCriterion("NewUpdate is not null");
            return (Criteria) this;
        }

        public Criteria andNewupdateEqualTo(Date value) {
            addCriterion("NewUpdate =", value, "newupdate");
            return (Criteria) this;
        }

        public Criteria andNewupdateNotEqualTo(Date value) {
            addCriterion("NewUpdate <>", value, "newupdate");
            return (Criteria) this;
        }

        public Criteria andNewupdateGreaterThan(Date value) {
            addCriterion("NewUpdate >", value, "newupdate");
            return (Criteria) this;
        }

        public Criteria andNewupdateGreaterThanOrEqualTo(Date value) {
            addCriterion("NewUpdate >=", value, "newupdate");
            return (Criteria) this;
        }

        public Criteria andNewupdateLessThan(Date value) {
            addCriterion("NewUpdate <", value, "newupdate");
            return (Criteria) this;
        }

        public Criteria andNewupdateLessThanOrEqualTo(Date value) {
            addCriterion("NewUpdate <=", value, "newupdate");
            return (Criteria) this;
        }

        public Criteria andNewupdateIn(List<Date> values) {
            addCriterion("NewUpdate in", values, "newupdate");
            return (Criteria) this;
        }

        public Criteria andNewupdateNotIn(List<Date> values) {
            addCriterion("NewUpdate not in", values, "newupdate");
            return (Criteria) this;
        }

        public Criteria andNewupdateBetween(Date value1, Date value2) {
            addCriterion("NewUpdate between", value1, value2, "newupdate");
            return (Criteria) this;
        }

        public Criteria andNewupdateNotBetween(Date value1, Date value2) {
            addCriterion("NewUpdate not between", value1, value2, "newupdate");
            return (Criteria) this;
        }

        public Criteria andRevfield1IsNull() {
            addCriterion("RevField1 is null");
            return (Criteria) this;
        }

        public Criteria andRevfield1IsNotNull() {
            addCriterion("RevField1 is not null");
            return (Criteria) this;
        }

        public Criteria andRevfield1EqualTo(String value) {
            addCriterion("RevField1 =", value, "revfield1");
            return (Criteria) this;
        }

        public Criteria andRevfield1NotEqualTo(String value) {
            addCriterion("RevField1 <>", value, "revfield1");
            return (Criteria) this;
        }

        public Criteria andRevfield1GreaterThan(String value) {
            addCriterion("RevField1 >", value, "revfield1");
            return (Criteria) this;
        }

        public Criteria andRevfield1GreaterThanOrEqualTo(String value) {
            addCriterion("RevField1 >=", value, "revfield1");
            return (Criteria) this;
        }

        public Criteria andRevfield1LessThan(String value) {
            addCriterion("RevField1 <", value, "revfield1");
            return (Criteria) this;
        }

        public Criteria andRevfield1LessThanOrEqualTo(String value) {
            addCriterion("RevField1 <=", value, "revfield1");
            return (Criteria) this;
        }

        public Criteria andRevfield1Like(String value) {
            addCriterion("RevField1 like", value, "revfield1");
            return (Criteria) this;
        }

        public Criteria andRevfield1NotLike(String value) {
            addCriterion("RevField1 not like", value, "revfield1");
            return (Criteria) this;
        }

        public Criteria andRevfield1In(List<String> values) {
            addCriterion("RevField1 in", values, "revfield1");
            return (Criteria) this;
        }

        public Criteria andRevfield1NotIn(List<String> values) {
            addCriterion("RevField1 not in", values, "revfield1");
            return (Criteria) this;
        }

        public Criteria andRevfield1Between(String value1, String value2) {
            addCriterion("RevField1 between", value1, value2, "revfield1");
            return (Criteria) this;
        }

        public Criteria andRevfield1NotBetween(String value1, String value2) {
            addCriterion("RevField1 not between", value1, value2, "revfield1");
            return (Criteria) this;
        }

        public Criteria andRevfield2IsNull() {
            addCriterion("RevField2 is null");
            return (Criteria) this;
        }

        public Criteria andRevfield2IsNotNull() {
            addCriterion("RevField2 is not null");
            return (Criteria) this;
        }

        public Criteria andRevfield2EqualTo(String value) {
            addCriterion("RevField2 =", value, "revfield2");
            return (Criteria) this;
        }

        public Criteria andRevfield2NotEqualTo(String value) {
            addCriterion("RevField2 <>", value, "revfield2");
            return (Criteria) this;
        }

        public Criteria andRevfield2GreaterThan(String value) {
            addCriterion("RevField2 >", value, "revfield2");
            return (Criteria) this;
        }

        public Criteria andRevfield2GreaterThanOrEqualTo(String value) {
            addCriterion("RevField2 >=", value, "revfield2");
            return (Criteria) this;
        }

        public Criteria andRevfield2LessThan(String value) {
            addCriterion("RevField2 <", value, "revfield2");
            return (Criteria) this;
        }

        public Criteria andRevfield2LessThanOrEqualTo(String value) {
            addCriterion("RevField2 <=", value, "revfield2");
            return (Criteria) this;
        }

        public Criteria andRevfield2Like(String value) {
            addCriterion("RevField2 like", value, "revfield2");
            return (Criteria) this;
        }

        public Criteria andRevfield2NotLike(String value) {
            addCriterion("RevField2 not like", value, "revfield2");
            return (Criteria) this;
        }

        public Criteria andRevfield2In(List<String> values) {
            addCriterion("RevField2 in", values, "revfield2");
            return (Criteria) this;
        }

        public Criteria andRevfield2NotIn(List<String> values) {
            addCriterion("RevField2 not in", values, "revfield2");
            return (Criteria) this;
        }

        public Criteria andRevfield2Between(String value1, String value2) {
            addCriterion("RevField2 between", value1, value2, "revfield2");
            return (Criteria) this;
        }

        public Criteria andRevfield2NotBetween(String value1, String value2) {
            addCriterion("RevField2 not between", value1, value2, "revfield2");
            return (Criteria) this;
        }

        public Criteria andRevfield3IsNull() {
            addCriterion("RevField3 is null");
            return (Criteria) this;
        }

        public Criteria andRevfield3IsNotNull() {
            addCriterion("RevField3 is not null");
            return (Criteria) this;
        }

        public Criteria andRevfield3EqualTo(String value) {
            addCriterion("RevField3 =", value, "revfield3");
            return (Criteria) this;
        }

        public Criteria andRevfield3NotEqualTo(String value) {
            addCriterion("RevField3 <>", value, "revfield3");
            return (Criteria) this;
        }

        public Criteria andRevfield3GreaterThan(String value) {
            addCriterion("RevField3 >", value, "revfield3");
            return (Criteria) this;
        }

        public Criteria andRevfield3GreaterThanOrEqualTo(String value) {
            addCriterion("RevField3 >=", value, "revfield3");
            return (Criteria) this;
        }

        public Criteria andRevfield3LessThan(String value) {
            addCriterion("RevField3 <", value, "revfield3");
            return (Criteria) this;
        }

        public Criteria andRevfield3LessThanOrEqualTo(String value) {
            addCriterion("RevField3 <=", value, "revfield3");
            return (Criteria) this;
        }

        public Criteria andRevfield3Like(String value) {
            addCriterion("RevField3 like", value, "revfield3");
            return (Criteria) this;
        }

        public Criteria andRevfield3NotLike(String value) {
            addCriterion("RevField3 not like", value, "revfield3");
            return (Criteria) this;
        }

        public Criteria andRevfield3In(List<String> values) {
            addCriterion("RevField3 in", values, "revfield3");
            return (Criteria) this;
        }

        public Criteria andRevfield3NotIn(List<String> values) {
            addCriterion("RevField3 not in", values, "revfield3");
            return (Criteria) this;
        }

        public Criteria andRevfield3Between(String value1, String value2) {
            addCriterion("RevField3 between", value1, value2, "revfield3");
            return (Criteria) this;
        }

        public Criteria andRevfield3NotBetween(String value1, String value2) {
            addCriterion("RevField3 not between", value1, value2, "revfield3");
            return (Criteria) this;
        }

        public Criteria andRevfield4IsNull() {
            addCriterion("RevField4 is null");
            return (Criteria) this;
        }

        public Criteria andRevfield4IsNotNull() {
            addCriterion("RevField4 is not null");
            return (Criteria) this;
        }

        public Criteria andRevfield4EqualTo(String value) {
            addCriterion("RevField4 =", value, "revfield4");
            return (Criteria) this;
        }

        public Criteria andRevfield4NotEqualTo(String value) {
            addCriterion("RevField4 <>", value, "revfield4");
            return (Criteria) this;
        }

        public Criteria andRevfield4GreaterThan(String value) {
            addCriterion("RevField4 >", value, "revfield4");
            return (Criteria) this;
        }

        public Criteria andRevfield4GreaterThanOrEqualTo(String value) {
            addCriterion("RevField4 >=", value, "revfield4");
            return (Criteria) this;
        }

        public Criteria andRevfield4LessThan(String value) {
            addCriterion("RevField4 <", value, "revfield4");
            return (Criteria) this;
        }

        public Criteria andRevfield4LessThanOrEqualTo(String value) {
            addCriterion("RevField4 <=", value, "revfield4");
            return (Criteria) this;
        }

        public Criteria andRevfield4Like(String value) {
            addCriterion("RevField4 like", value, "revfield4");
            return (Criteria) this;
        }

        public Criteria andRevfield4NotLike(String value) {
            addCriterion("RevField4 not like", value, "revfield4");
            return (Criteria) this;
        }

        public Criteria andRevfield4In(List<String> values) {
            addCriterion("RevField4 in", values, "revfield4");
            return (Criteria) this;
        }

        public Criteria andRevfield4NotIn(List<String> values) {
            addCriterion("RevField4 not in", values, "revfield4");
            return (Criteria) this;
        }

        public Criteria andRevfield4Between(String value1, String value2) {
            addCriterion("RevField4 between", value1, value2, "revfield4");
            return (Criteria) this;
        }

        public Criteria andRevfield4NotBetween(String value1, String value2) {
            addCriterion("RevField4 not between", value1, value2, "revfield4");
            return (Criteria) this;
        }

        public Criteria andRevdate5IsNull() {
            addCriterion("RevDate5 is null");
            return (Criteria) this;
        }

        public Criteria andRevdate5IsNotNull() {
            addCriterion("RevDate5 is not null");
            return (Criteria) this;
        }

        public Criteria andRevdate5EqualTo(Date value) {
            addCriterion("RevDate5 =", value, "revdate5");
            return (Criteria) this;
        }

        public Criteria andRevdate5NotEqualTo(Date value) {
            addCriterion("RevDate5 <>", value, "revdate5");
            return (Criteria) this;
        }

        public Criteria andRevdate5GreaterThan(Date value) {
            addCriterion("RevDate5 >", value, "revdate5");
            return (Criteria) this;
        }

        public Criteria andRevdate5GreaterThanOrEqualTo(Date value) {
            addCriterion("RevDate5 >=", value, "revdate5");
            return (Criteria) this;
        }

        public Criteria andRevdate5LessThan(Date value) {
            addCriterion("RevDate5 <", value, "revdate5");
            return (Criteria) this;
        }

        public Criteria andRevdate5LessThanOrEqualTo(Date value) {
            addCriterion("RevDate5 <=", value, "revdate5");
            return (Criteria) this;
        }

        public Criteria andRevdate5In(List<Date> values) {
            addCriterion("RevDate5 in", values, "revdate5");
            return (Criteria) this;
        }

        public Criteria andRevdate5NotIn(List<Date> values) {
            addCriterion("RevDate5 not in", values, "revdate5");
            return (Criteria) this;
        }

        public Criteria andRevdate5Between(Date value1, Date value2) {
            addCriterion("RevDate5 between", value1, value2, "revdate5");
            return (Criteria) this;
        }

        public Criteria andRevdate5NotBetween(Date value1, Date value2) {
            addCriterion("RevDate5 not between", value1, value2, "revdate5");
            return (Criteria) this;
        }

        public Criteria andUsertypeIsNull() {
            addCriterion("UserType is null");
            return (Criteria) this;
        }

        public Criteria andUsertypeIsNotNull() {
            addCriterion("UserType is not null");
            return (Criteria) this;
        }

        public Criteria andUsertypeEqualTo(String value) {
            addCriterion("UserType =", value, "usertype");
            return (Criteria) this;
        }

        public Criteria andUsertypeNotEqualTo(String value) {
            addCriterion("UserType <>", value, "usertype");
            return (Criteria) this;
        }

        public Criteria andUsertypeGreaterThan(String value) {
            addCriterion("UserType >", value, "usertype");
            return (Criteria) this;
        }

        public Criteria andUsertypeGreaterThanOrEqualTo(String value) {
            addCriterion("UserType >=", value, "usertype");
            return (Criteria) this;
        }

        public Criteria andUsertypeLessThan(String value) {
            addCriterion("UserType <", value, "usertype");
            return (Criteria) this;
        }

        public Criteria andUsertypeLessThanOrEqualTo(String value) {
            addCriterion("UserType <=", value, "usertype");
            return (Criteria) this;
        }

        public Criteria andUsertypeLike(String value) {
            addCriterion("UserType like", value, "usertype");
            return (Criteria) this;
        }

        public Criteria andUsertypeNotLike(String value) {
            addCriterion("UserType not like", value, "usertype");
            return (Criteria) this;
        }

        public Criteria andUsertypeIn(List<String> values) {
            addCriterion("UserType in", values, "usertype");
            return (Criteria) this;
        }

        public Criteria andUsertypeNotIn(List<String> values) {
            addCriterion("UserType not in", values, "usertype");
            return (Criteria) this;
        }

        public Criteria andUsertypeBetween(String value1, String value2) {
            addCriterion("UserType between", value1, value2, "usertype");
            return (Criteria) this;
        }

        public Criteria andUsertypeNotBetween(String value1, String value2) {
            addCriterion("UserType not between", value1, value2, "usertype");
            return (Criteria) this;
        }

        public Criteria andRelationnoIsNull() {
            addCriterion("RelationNo is null");
            return (Criteria) this;
        }

        public Criteria andRelationnoIsNotNull() {
            addCriterion("RelationNo is not null");
            return (Criteria) this;
        }

        public Criteria andRelationnoEqualTo(String value) {
            addCriterion("RelationNo =", value, "relationno");
            return (Criteria) this;
        }

        public Criteria andRelationnoNotEqualTo(String value) {
            addCriterion("RelationNo <>", value, "relationno");
            return (Criteria) this;
        }

        public Criteria andRelationnoGreaterThan(String value) {
            addCriterion("RelationNo >", value, "relationno");
            return (Criteria) this;
        }

        public Criteria andRelationnoGreaterThanOrEqualTo(String value) {
            addCriterion("RelationNo >=", value, "relationno");
            return (Criteria) this;
        }

        public Criteria andRelationnoLessThan(String value) {
            addCriterion("RelationNo <", value, "relationno");
            return (Criteria) this;
        }

        public Criteria andRelationnoLessThanOrEqualTo(String value) {
            addCriterion("RelationNo <=", value, "relationno");
            return (Criteria) this;
        }

        public Criteria andRelationnoLike(String value) {
            addCriterion("RelationNo like", value, "relationno");
            return (Criteria) this;
        }

        public Criteria andRelationnoNotLike(String value) {
            addCriterion("RelationNo not like", value, "relationno");
            return (Criteria) this;
        }

        public Criteria andRelationnoIn(List<String> values) {
            addCriterion("RelationNo in", values, "relationno");
            return (Criteria) this;
        }

        public Criteria andRelationnoNotIn(List<String> values) {
            addCriterion("RelationNo not in", values, "relationno");
            return (Criteria) this;
        }

        public Criteria andRelationnoBetween(String value1, String value2) {
            addCriterion("RelationNo between", value1, value2, "relationno");
            return (Criteria) this;
        }

        public Criteria andRelationnoNotBetween(String value1, String value2) {
            addCriterion("RelationNo not between", value1, value2, "relationno");
            return (Criteria) this;
        }

        public Criteria andAreanoIsNull() {
            addCriterion("AreaNo is null");
            return (Criteria) this;
        }

        public Criteria andAreanoIsNotNull() {
            addCriterion("AreaNo is not null");
            return (Criteria) this;
        }

        public Criteria andAreanoEqualTo(String value) {
            addCriterion("AreaNo =", value, "areano");
            return (Criteria) this;
        }

        public Criteria andAreanoNotEqualTo(String value) {
            addCriterion("AreaNo <>", value, "areano");
            return (Criteria) this;
        }

        public Criteria andAreanoGreaterThan(String value) {
            addCriterion("AreaNo >", value, "areano");
            return (Criteria) this;
        }

        public Criteria andAreanoGreaterThanOrEqualTo(String value) {
            addCriterion("AreaNo >=", value, "areano");
            return (Criteria) this;
        }

        public Criteria andAreanoLessThan(String value) {
            addCriterion("AreaNo <", value, "areano");
            return (Criteria) this;
        }

        public Criteria andAreanoLessThanOrEqualTo(String value) {
            addCriterion("AreaNo <=", value, "areano");
            return (Criteria) this;
        }

        public Criteria andAreanoLike(String value) {
            addCriterion("AreaNo like", value, "areano");
            return (Criteria) this;
        }

        public Criteria andAreanoNotLike(String value) {
            addCriterion("AreaNo not like", value, "areano");
            return (Criteria) this;
        }

        public Criteria andAreanoIn(List<String> values) {
            addCriterion("AreaNo in", values, "areano");
            return (Criteria) this;
        }

        public Criteria andAreanoNotIn(List<String> values) {
            addCriterion("AreaNo not in", values, "areano");
            return (Criteria) this;
        }

        public Criteria andAreanoBetween(String value1, String value2) {
            addCriterion("AreaNo between", value1, value2, "areano");
            return (Criteria) this;
        }

        public Criteria andAreanoNotBetween(String value1, String value2) {
            addCriterion("AreaNo not between", value1, value2, "areano");
            return (Criteria) this;
        }

        public Criteria andUserrankIsNull() {
            addCriterion("UserRank is null");
            return (Criteria) this;
        }

        public Criteria andUserrankIsNotNull() {
            addCriterion("UserRank is not null");
            return (Criteria) this;
        }

        public Criteria andUserrankEqualTo(String value) {
            addCriterion("UserRank =", value, "userrank");
            return (Criteria) this;
        }

        public Criteria andUserrankNotEqualTo(String value) {
            addCriterion("UserRank <>", value, "userrank");
            return (Criteria) this;
        }

        public Criteria andUserrankGreaterThan(String value) {
            addCriterion("UserRank >", value, "userrank");
            return (Criteria) this;
        }

        public Criteria andUserrankGreaterThanOrEqualTo(String value) {
            addCriterion("UserRank >=", value, "userrank");
            return (Criteria) this;
        }

        public Criteria andUserrankLessThan(String value) {
            addCriterion("UserRank <", value, "userrank");
            return (Criteria) this;
        }

        public Criteria andUserrankLessThanOrEqualTo(String value) {
            addCriterion("UserRank <=", value, "userrank");
            return (Criteria) this;
        }

        public Criteria andUserrankLike(String value) {
            addCriterion("UserRank like", value, "userrank");
            return (Criteria) this;
        }

        public Criteria andUserrankNotLike(String value) {
            addCriterion("UserRank not like", value, "userrank");
            return (Criteria) this;
        }

        public Criteria andUserrankIn(List<String> values) {
            addCriterion("UserRank in", values, "userrank");
            return (Criteria) this;
        }

        public Criteria andUserrankNotIn(List<String> values) {
            addCriterion("UserRank not in", values, "userrank");
            return (Criteria) this;
        }

        public Criteria andUserrankBetween(String value1, String value2) {
            addCriterion("UserRank between", value1, value2, "userrank");
            return (Criteria) this;
        }

        public Criteria andUserrankNotBetween(String value1, String value2) {
            addCriterion("UserRank not between", value1, value2, "userrank");
            return (Criteria) this;
        }

        public Criteria andLastpointIsNull() {
            addCriterion("LastPoint is null");
            return (Criteria) this;
        }

        public Criteria andLastpointIsNotNull() {
            addCriterion("LastPoint is not null");
            return (Criteria) this;
        }

        public Criteria andLastpointEqualTo(BigDecimal value) {
            addCriterion("LastPoint =", value, "lastpoint");
            return (Criteria) this;
        }

        public Criteria andLastpointNotEqualTo(BigDecimal value) {
            addCriterion("LastPoint <>", value, "lastpoint");
            return (Criteria) this;
        }

        public Criteria andLastpointGreaterThan(BigDecimal value) {
            addCriterion("LastPoint >", value, "lastpoint");
            return (Criteria) this;
        }

        public Criteria andLastpointGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("LastPoint >=", value, "lastpoint");
            return (Criteria) this;
        }

        public Criteria andLastpointLessThan(BigDecimal value) {
            addCriterion("LastPoint <", value, "lastpoint");
            return (Criteria) this;
        }

        public Criteria andLastpointLessThanOrEqualTo(BigDecimal value) {
            addCriterion("LastPoint <=", value, "lastpoint");
            return (Criteria) this;
        }

        public Criteria andLastpointIn(List<BigDecimal> values) {
            addCriterion("LastPoint in", values, "lastpoint");
            return (Criteria) this;
        }

        public Criteria andLastpointNotIn(List<BigDecimal> values) {
            addCriterion("LastPoint not in", values, "lastpoint");
            return (Criteria) this;
        }

        public Criteria andLastpointBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("LastPoint between", value1, value2, "lastpoint");
            return (Criteria) this;
        }

        public Criteria andLastpointNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("LastPoint not between", value1, value2, "lastpoint");
            return (Criteria) this;
        }

        public Criteria andHearfromIsNull() {
            addCriterion("HearFrom is null");
            return (Criteria) this;
        }

        public Criteria andHearfromIsNotNull() {
            addCriterion("HearFrom is not null");
            return (Criteria) this;
        }

        public Criteria andHearfromEqualTo(String value) {
            addCriterion("HearFrom =", value, "hearfrom");
            return (Criteria) this;
        }

        public Criteria andHearfromNotEqualTo(String value) {
            addCriterion("HearFrom <>", value, "hearfrom");
            return (Criteria) this;
        }

        public Criteria andHearfromGreaterThan(String value) {
            addCriterion("HearFrom >", value, "hearfrom");
            return (Criteria) this;
        }

        public Criteria andHearfromGreaterThanOrEqualTo(String value) {
            addCriterion("HearFrom >=", value, "hearfrom");
            return (Criteria) this;
        }

        public Criteria andHearfromLessThan(String value) {
            addCriterion("HearFrom <", value, "hearfrom");
            return (Criteria) this;
        }

        public Criteria andHearfromLessThanOrEqualTo(String value) {
            addCriterion("HearFrom <=", value, "hearfrom");
            return (Criteria) this;
        }

        public Criteria andHearfromLike(String value) {
            addCriterion("HearFrom like", value, "hearfrom");
            return (Criteria) this;
        }

        public Criteria andHearfromNotLike(String value) {
            addCriterion("HearFrom not like", value, "hearfrom");
            return (Criteria) this;
        }

        public Criteria andHearfromIn(List<String> values) {
            addCriterion("HearFrom in", values, "hearfrom");
            return (Criteria) this;
        }

        public Criteria andHearfromNotIn(List<String> values) {
            addCriterion("HearFrom not in", values, "hearfrom");
            return (Criteria) this;
        }

        public Criteria andHearfromBetween(String value1, String value2) {
            addCriterion("HearFrom between", value1, value2, "hearfrom");
            return (Criteria) this;
        }

        public Criteria andHearfromNotBetween(String value1, String value2) {
            addCriterion("HearFrom not between", value1, value2, "hearfrom");
            return (Criteria) this;
        }

        public Criteria andBacktimesIsNull() {
            addCriterion("BackTimes is null");
            return (Criteria) this;
        }

        public Criteria andBacktimesIsNotNull() {
            addCriterion("BackTimes is not null");
            return (Criteria) this;
        }

        public Criteria andBacktimesEqualTo(Integer value) {
            addCriterion("BackTimes =", value, "backtimes");
            return (Criteria) this;
        }

        public Criteria andBacktimesNotEqualTo(Integer value) {
            addCriterion("BackTimes <>", value, "backtimes");
            return (Criteria) this;
        }

        public Criteria andBacktimesGreaterThan(Integer value) {
            addCriterion("BackTimes >", value, "backtimes");
            return (Criteria) this;
        }

        public Criteria andBacktimesGreaterThanOrEqualTo(Integer value) {
            addCriterion("BackTimes >=", value, "backtimes");
            return (Criteria) this;
        }

        public Criteria andBacktimesLessThan(Integer value) {
            addCriterion("BackTimes <", value, "backtimes");
            return (Criteria) this;
        }

        public Criteria andBacktimesLessThanOrEqualTo(Integer value) {
            addCriterion("BackTimes <=", value, "backtimes");
            return (Criteria) this;
        }

        public Criteria andBacktimesIn(List<Integer> values) {
            addCriterion("BackTimes in", values, "backtimes");
            return (Criteria) this;
        }

        public Criteria andBacktimesNotIn(List<Integer> values) {
            addCriterion("BackTimes not in", values, "backtimes");
            return (Criteria) this;
        }

        public Criteria andBacktimesBetween(Integer value1, Integer value2) {
            addCriterion("BackTimes between", value1, value2, "backtimes");
            return (Criteria) this;
        }

        public Criteria andBacktimesNotBetween(Integer value1, Integer value2) {
            addCriterion("BackTimes not between", value1, value2, "backtimes");
            return (Criteria) this;
        }

        public Criteria andAppealtimesIsNull() {
            addCriterion("AppealTimes is null");
            return (Criteria) this;
        }

        public Criteria andAppealtimesIsNotNull() {
            addCriterion("AppealTimes is not null");
            return (Criteria) this;
        }

        public Criteria andAppealtimesEqualTo(Integer value) {
            addCriterion("AppealTimes =", value, "appealtimes");
            return (Criteria) this;
        }

        public Criteria andAppealtimesNotEqualTo(Integer value) {
            addCriterion("AppealTimes <>", value, "appealtimes");
            return (Criteria) this;
        }

        public Criteria andAppealtimesGreaterThan(Integer value) {
            addCriterion("AppealTimes >", value, "appealtimes");
            return (Criteria) this;
        }

        public Criteria andAppealtimesGreaterThanOrEqualTo(Integer value) {
            addCriterion("AppealTimes >=", value, "appealtimes");
            return (Criteria) this;
        }

        public Criteria andAppealtimesLessThan(Integer value) {
            addCriterion("AppealTimes <", value, "appealtimes");
            return (Criteria) this;
        }

        public Criteria andAppealtimesLessThanOrEqualTo(Integer value) {
            addCriterion("AppealTimes <=", value, "appealtimes");
            return (Criteria) this;
        }

        public Criteria andAppealtimesIn(List<Integer> values) {
            addCriterion("AppealTimes in", values, "appealtimes");
            return (Criteria) this;
        }

        public Criteria andAppealtimesNotIn(List<Integer> values) {
            addCriterion("AppealTimes not in", values, "appealtimes");
            return (Criteria) this;
        }

        public Criteria andAppealtimesBetween(Integer value1, Integer value2) {
            addCriterion("AppealTimes between", value1, value2, "appealtimes");
            return (Criteria) this;
        }

        public Criteria andAppealtimesNotBetween(Integer value1, Integer value2) {
            addCriterion("AppealTimes not between", value1, value2, "appealtimes");
            return (Criteria) this;
        }

        public Criteria andBonusIsNull() {
            addCriterion("Bonus is null");
            return (Criteria) this;
        }

        public Criteria andBonusIsNotNull() {
            addCriterion("Bonus is not null");
            return (Criteria) this;
        }

        public Criteria andBonusEqualTo(BigDecimal value) {
            addCriterion("Bonus =", value, "bonus");
            return (Criteria) this;
        }

        public Criteria andBonusNotEqualTo(BigDecimal value) {
            addCriterion("Bonus <>", value, "bonus");
            return (Criteria) this;
        }

        public Criteria andBonusGreaterThan(BigDecimal value) {
            addCriterion("Bonus >", value, "bonus");
            return (Criteria) this;
        }

        public Criteria andBonusGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("Bonus >=", value, "bonus");
            return (Criteria) this;
        }

        public Criteria andBonusLessThan(BigDecimal value) {
            addCriterion("Bonus <", value, "bonus");
            return (Criteria) this;
        }

        public Criteria andBonusLessThanOrEqualTo(BigDecimal value) {
            addCriterion("Bonus <=", value, "bonus");
            return (Criteria) this;
        }

        public Criteria andBonusIn(List<BigDecimal> values) {
            addCriterion("Bonus in", values, "bonus");
            return (Criteria) this;
        }

        public Criteria andBonusNotIn(List<BigDecimal> values) {
            addCriterion("Bonus not in", values, "bonus");
            return (Criteria) this;
        }

        public Criteria andBonusBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("Bonus between", value1, value2, "bonus");
            return (Criteria) this;
        }

        public Criteria andBonusNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("Bonus not between", value1, value2, "bonus");
            return (Criteria) this;
        }

        public Criteria andDepositamtIsNull() {
            addCriterion("DepositAmt is null");
            return (Criteria) this;
        }

        public Criteria andDepositamtIsNotNull() {
            addCriterion("DepositAmt is not null");
            return (Criteria) this;
        }

        public Criteria andDepositamtEqualTo(BigDecimal value) {
            addCriterion("DepositAmt =", value, "depositamt");
            return (Criteria) this;
        }

        public Criteria andDepositamtNotEqualTo(BigDecimal value) {
            addCriterion("DepositAmt <>", value, "depositamt");
            return (Criteria) this;
        }

        public Criteria andDepositamtGreaterThan(BigDecimal value) {
            addCriterion("DepositAmt >", value, "depositamt");
            return (Criteria) this;
        }

        public Criteria andDepositamtGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("DepositAmt >=", value, "depositamt");
            return (Criteria) this;
        }

        public Criteria andDepositamtLessThan(BigDecimal value) {
            addCriterion("DepositAmt <", value, "depositamt");
            return (Criteria) this;
        }

        public Criteria andDepositamtLessThanOrEqualTo(BigDecimal value) {
            addCriterion("DepositAmt <=", value, "depositamt");
            return (Criteria) this;
        }

        public Criteria andDepositamtIn(List<BigDecimal> values) {
            addCriterion("DepositAmt in", values, "depositamt");
            return (Criteria) this;
        }

        public Criteria andDepositamtNotIn(List<BigDecimal> values) {
            addCriterion("DepositAmt not in", values, "depositamt");
            return (Criteria) this;
        }

        public Criteria andDepositamtBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("DepositAmt between", value1, value2, "depositamt");
            return (Criteria) this;
        }

        public Criteria andDepositamtNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("DepositAmt not between", value1, value2, "depositamt");
            return (Criteria) this;
        }

        public Criteria andNewshoppingtimeIsNull() {
            addCriterion("NewShoppingTime is null");
            return (Criteria) this;
        }

        public Criteria andNewshoppingtimeIsNotNull() {
            addCriterion("NewShoppingTime is not null");
            return (Criteria) this;
        }

        public Criteria andNewshoppingtimeEqualTo(Date value) {
            addCriterion("NewShoppingTime =", value, "newshoppingtime");
            return (Criteria) this;
        }

        public Criteria andNewshoppingtimeNotEqualTo(Date value) {
            addCriterion("NewShoppingTime <>", value, "newshoppingtime");
            return (Criteria) this;
        }

        public Criteria andNewshoppingtimeGreaterThan(Date value) {
            addCriterion("NewShoppingTime >", value, "newshoppingtime");
            return (Criteria) this;
        }

        public Criteria andNewshoppingtimeGreaterThanOrEqualTo(Date value) {
            addCriterion("NewShoppingTime >=", value, "newshoppingtime");
            return (Criteria) this;
        }

        public Criteria andNewshoppingtimeLessThan(Date value) {
            addCriterion("NewShoppingTime <", value, "newshoppingtime");
            return (Criteria) this;
        }

        public Criteria andNewshoppingtimeLessThanOrEqualTo(Date value) {
            addCriterion("NewShoppingTime <=", value, "newshoppingtime");
            return (Criteria) this;
        }

        public Criteria andNewshoppingtimeIn(List<Date> values) {
            addCriterion("NewShoppingTime in", values, "newshoppingtime");
            return (Criteria) this;
        }

        public Criteria andNewshoppingtimeNotIn(List<Date> values) {
            addCriterion("NewShoppingTime not in", values, "newshoppingtime");
            return (Criteria) this;
        }

        public Criteria andNewshoppingtimeBetween(Date value1, Date value2) {
            addCriterion("NewShoppingTime between", value1, value2, "newshoppingtime");
            return (Criteria) this;
        }

        public Criteria andNewshoppingtimeNotBetween(Date value1, Date value2) {
            addCriterion("NewShoppingTime not between", value1, value2, "newshoppingtime");
            return (Criteria) this;
        }

        public Criteria andNewbacktimeIsNull() {
            addCriterion("NewBackTime is null");
            return (Criteria) this;
        }

        public Criteria andNewbacktimeIsNotNull() {
            addCriterion("NewBackTime is not null");
            return (Criteria) this;
        }

        public Criteria andNewbacktimeEqualTo(Date value) {
            addCriterion("NewBackTime =", value, "newbacktime");
            return (Criteria) this;
        }

        public Criteria andNewbacktimeNotEqualTo(Date value) {
            addCriterion("NewBackTime <>", value, "newbacktime");
            return (Criteria) this;
        }

        public Criteria andNewbacktimeGreaterThan(Date value) {
            addCriterion("NewBackTime >", value, "newbacktime");
            return (Criteria) this;
        }

        public Criteria andNewbacktimeGreaterThanOrEqualTo(Date value) {
            addCriterion("NewBackTime >=", value, "newbacktime");
            return (Criteria) this;
        }

        public Criteria andNewbacktimeLessThan(Date value) {
            addCriterion("NewBackTime <", value, "newbacktime");
            return (Criteria) this;
        }

        public Criteria andNewbacktimeLessThanOrEqualTo(Date value) {
            addCriterion("NewBackTime <=", value, "newbacktime");
            return (Criteria) this;
        }

        public Criteria andNewbacktimeIn(List<Date> values) {
            addCriterion("NewBackTime in", values, "newbacktime");
            return (Criteria) this;
        }

        public Criteria andNewbacktimeNotIn(List<Date> values) {
            addCriterion("NewBackTime not in", values, "newbacktime");
            return (Criteria) this;
        }

        public Criteria andNewbacktimeBetween(Date value1, Date value2) {
            addCriterion("NewBackTime between", value1, value2, "newbacktime");
            return (Criteria) this;
        }

        public Criteria andNewbacktimeNotBetween(Date value1, Date value2) {
            addCriterion("NewBackTime not between", value1, value2, "newbacktime");
            return (Criteria) this;
        }

        public Criteria andStopupdateIsNull() {
            addCriterion("StopUpdate is null");
            return (Criteria) this;
        }

        public Criteria andStopupdateIsNotNull() {
            addCriterion("StopUpdate is not null");
            return (Criteria) this;
        }

        public Criteria andStopupdateEqualTo(Date value) {
            addCriterion("StopUpdate =", value, "stopupdate");
            return (Criteria) this;
        }

        public Criteria andStopupdateNotEqualTo(Date value) {
            addCriterion("StopUpdate <>", value, "stopupdate");
            return (Criteria) this;
        }

        public Criteria andStopupdateGreaterThan(Date value) {
            addCriterion("StopUpdate >", value, "stopupdate");
            return (Criteria) this;
        }

        public Criteria andStopupdateGreaterThanOrEqualTo(Date value) {
            addCriterion("StopUpdate >=", value, "stopupdate");
            return (Criteria) this;
        }

        public Criteria andStopupdateLessThan(Date value) {
            addCriterion("StopUpdate <", value, "stopupdate");
            return (Criteria) this;
        }

        public Criteria andStopupdateLessThanOrEqualTo(Date value) {
            addCriterion("StopUpdate <=", value, "stopupdate");
            return (Criteria) this;
        }

        public Criteria andStopupdateIn(List<Date> values) {
            addCriterion("StopUpdate in", values, "stopupdate");
            return (Criteria) this;
        }

        public Criteria andStopupdateNotIn(List<Date> values) {
            addCriterion("StopUpdate not in", values, "stopupdate");
            return (Criteria) this;
        }

        public Criteria andStopupdateBetween(Date value1, Date value2) {
            addCriterion("StopUpdate between", value1, value2, "stopupdate");
            return (Criteria) this;
        }

        public Criteria andStopupdateNotBetween(Date value1, Date value2) {
            addCriterion("StopUpdate not between", value1, value2, "stopupdate");
            return (Criteria) this;
        }

        public Criteria andStopreasonIsNull() {
            addCriterion("StopReason is null");
            return (Criteria) this;
        }

        public Criteria andStopreasonIsNotNull() {
            addCriterion("StopReason is not null");
            return (Criteria) this;
        }

        public Criteria andStopreasonEqualTo(String value) {
            addCriterion("StopReason =", value, "stopreason");
            return (Criteria) this;
        }

        public Criteria andStopreasonNotEqualTo(String value) {
            addCriterion("StopReason <>", value, "stopreason");
            return (Criteria) this;
        }

        public Criteria andStopreasonGreaterThan(String value) {
            addCriterion("StopReason >", value, "stopreason");
            return (Criteria) this;
        }

        public Criteria andStopreasonGreaterThanOrEqualTo(String value) {
            addCriterion("StopReason >=", value, "stopreason");
            return (Criteria) this;
        }

        public Criteria andStopreasonLessThan(String value) {
            addCriterion("StopReason <", value, "stopreason");
            return (Criteria) this;
        }

        public Criteria andStopreasonLessThanOrEqualTo(String value) {
            addCriterion("StopReason <=", value, "stopreason");
            return (Criteria) this;
        }

        public Criteria andStopreasonLike(String value) {
            addCriterion("StopReason like", value, "stopreason");
            return (Criteria) this;
        }

        public Criteria andStopreasonNotLike(String value) {
            addCriterion("StopReason not like", value, "stopreason");
            return (Criteria) this;
        }

        public Criteria andStopreasonIn(List<String> values) {
            addCriterion("StopReason in", values, "stopreason");
            return (Criteria) this;
        }

        public Criteria andStopreasonNotIn(List<String> values) {
            addCriterion("StopReason not in", values, "stopreason");
            return (Criteria) this;
        }

        public Criteria andStopreasonBetween(String value1, String value2) {
            addCriterion("StopReason between", value1, value2, "stopreason");
            return (Criteria) this;
        }

        public Criteria andStopreasonNotBetween(String value1, String value2) {
            addCriterion("StopReason not between", value1, value2, "stopreason");
            return (Criteria) this;
        }

        public Criteria andBlacktimeIsNull() {
            addCriterion("BlackTime is null");
            return (Criteria) this;
        }

        public Criteria andBlacktimeIsNotNull() {
            addCriterion("BlackTime is not null");
            return (Criteria) this;
        }

        public Criteria andBlacktimeEqualTo(Date value) {
            addCriterion("BlackTime =", value, "blacktime");
            return (Criteria) this;
        }

        public Criteria andBlacktimeNotEqualTo(Date value) {
            addCriterion("BlackTime <>", value, "blacktime");
            return (Criteria) this;
        }

        public Criteria andBlacktimeGreaterThan(Date value) {
            addCriterion("BlackTime >", value, "blacktime");
            return (Criteria) this;
        }

        public Criteria andBlacktimeGreaterThanOrEqualTo(Date value) {
            addCriterion("BlackTime >=", value, "blacktime");
            return (Criteria) this;
        }

        public Criteria andBlacktimeLessThan(Date value) {
            addCriterion("BlackTime <", value, "blacktime");
            return (Criteria) this;
        }

        public Criteria andBlacktimeLessThanOrEqualTo(Date value) {
            addCriterion("BlackTime <=", value, "blacktime");
            return (Criteria) this;
        }

        public Criteria andBlacktimeIn(List<Date> values) {
            addCriterion("BlackTime in", values, "blacktime");
            return (Criteria) this;
        }

        public Criteria andBlacktimeNotIn(List<Date> values) {
            addCriterion("BlackTime not in", values, "blacktime");
            return (Criteria) this;
        }

        public Criteria andBlacktimeBetween(Date value1, Date value2) {
            addCriterion("BlackTime between", value1, value2, "blacktime");
            return (Criteria) this;
        }

        public Criteria andBlacktimeNotBetween(Date value1, Date value2) {
            addCriterion("BlackTime not between", value1, value2, "blacktime");
            return (Criteria) this;
        }

        public Criteria andQuestionIsNull() {
            addCriterion("Question is null");
            return (Criteria) this;
        }

        public Criteria andQuestionIsNotNull() {
            addCriterion("Question is not null");
            return (Criteria) this;
        }

        public Criteria andQuestionEqualTo(String value) {
            addCriterion("Question =", value, "question");
            return (Criteria) this;
        }

        public Criteria andQuestionNotEqualTo(String value) {
            addCriterion("Question <>", value, "question");
            return (Criteria) this;
        }

        public Criteria andQuestionGreaterThan(String value) {
            addCriterion("Question >", value, "question");
            return (Criteria) this;
        }

        public Criteria andQuestionGreaterThanOrEqualTo(String value) {
            addCriterion("Question >=", value, "question");
            return (Criteria) this;
        }

        public Criteria andQuestionLessThan(String value) {
            addCriterion("Question <", value, "question");
            return (Criteria) this;
        }

        public Criteria andQuestionLessThanOrEqualTo(String value) {
            addCriterion("Question <=", value, "question");
            return (Criteria) this;
        }

        public Criteria andQuestionLike(String value) {
            addCriterion("Question like", value, "question");
            return (Criteria) this;
        }

        public Criteria andQuestionNotLike(String value) {
            addCriterion("Question not like", value, "question");
            return (Criteria) this;
        }

        public Criteria andQuestionIn(List<String> values) {
            addCriterion("Question in", values, "question");
            return (Criteria) this;
        }

        public Criteria andQuestionNotIn(List<String> values) {
            addCriterion("Question not in", values, "question");
            return (Criteria) this;
        }

        public Criteria andQuestionBetween(String value1, String value2) {
            addCriterion("Question between", value1, value2, "question");
            return (Criteria) this;
        }

        public Criteria andQuestionNotBetween(String value1, String value2) {
            addCriterion("Question not between", value1, value2, "question");
            return (Criteria) this;
        }

        public Criteria andAnswerIsNull() {
            addCriterion("Answer is null");
            return (Criteria) this;
        }

        public Criteria andAnswerIsNotNull() {
            addCriterion("Answer is not null");
            return (Criteria) this;
        }

        public Criteria andAnswerEqualTo(String value) {
            addCriterion("Answer =", value, "answer");
            return (Criteria) this;
        }

        public Criteria andAnswerNotEqualTo(String value) {
            addCriterion("Answer <>", value, "answer");
            return (Criteria) this;
        }

        public Criteria andAnswerGreaterThan(String value) {
            addCriterion("Answer >", value, "answer");
            return (Criteria) this;
        }

        public Criteria andAnswerGreaterThanOrEqualTo(String value) {
            addCriterion("Answer >=", value, "answer");
            return (Criteria) this;
        }

        public Criteria andAnswerLessThan(String value) {
            addCriterion("Answer <", value, "answer");
            return (Criteria) this;
        }

        public Criteria andAnswerLessThanOrEqualTo(String value) {
            addCriterion("Answer <=", value, "answer");
            return (Criteria) this;
        }

        public Criteria andAnswerLike(String value) {
            addCriterion("Answer like", value, "answer");
            return (Criteria) this;
        }

        public Criteria andAnswerNotLike(String value) {
            addCriterion("Answer not like", value, "answer");
            return (Criteria) this;
        }

        public Criteria andAnswerIn(List<String> values) {
            addCriterion("Answer in", values, "answer");
            return (Criteria) this;
        }

        public Criteria andAnswerNotIn(List<String> values) {
            addCriterion("Answer not in", values, "answer");
            return (Criteria) this;
        }

        public Criteria andAnswerBetween(String value1, String value2) {
            addCriterion("Answer between", value1, value2, "answer");
            return (Criteria) this;
        }

        public Criteria andAnswerNotBetween(String value1, String value2) {
            addCriterion("Answer not between", value1, value2, "answer");
            return (Criteria) this;
        }

        public Criteria andLastloginIsNull() {
            addCriterion("LastLogin is null");
            return (Criteria) this;
        }

        public Criteria andLastloginIsNotNull() {
            addCriterion("LastLogin is not null");
            return (Criteria) this;
        }

        public Criteria andLastloginEqualTo(Date value) {
            addCriterion("LastLogin =", value, "lastlogin");
            return (Criteria) this;
        }

        public Criteria andLastloginNotEqualTo(Date value) {
            addCriterion("LastLogin <>", value, "lastlogin");
            return (Criteria) this;
        }

        public Criteria andLastloginGreaterThan(Date value) {
            addCriterion("LastLogin >", value, "lastlogin");
            return (Criteria) this;
        }

        public Criteria andLastloginGreaterThanOrEqualTo(Date value) {
            addCriterion("LastLogin >=", value, "lastlogin");
            return (Criteria) this;
        }

        public Criteria andLastloginLessThan(Date value) {
            addCriterion("LastLogin <", value, "lastlogin");
            return (Criteria) this;
        }

        public Criteria andLastloginLessThanOrEqualTo(Date value) {
            addCriterion("LastLogin <=", value, "lastlogin");
            return (Criteria) this;
        }

        public Criteria andLastloginIn(List<Date> values) {
            addCriterion("LastLogin in", values, "lastlogin");
            return (Criteria) this;
        }

        public Criteria andLastloginNotIn(List<Date> values) {
            addCriterion("LastLogin not in", values, "lastlogin");
            return (Criteria) this;
        }

        public Criteria andLastloginBetween(Date value1, Date value2) {
            addCriterion("LastLogin between", value1, value2, "lastlogin");
            return (Criteria) this;
        }

        public Criteria andLastloginNotBetween(Date value1, Date value2) {
            addCriterion("LastLogin not between", value1, value2, "lastlogin");
            return (Criteria) this;
        }

        public Criteria andLogintimesIsNull() {
            addCriterion("LoginTimes is null");
            return (Criteria) this;
        }

        public Criteria andLogintimesIsNotNull() {
            addCriterion("LoginTimes is not null");
            return (Criteria) this;
        }

        public Criteria andLogintimesEqualTo(Integer value) {
            addCriterion("LoginTimes =", value, "logintimes");
            return (Criteria) this;
        }

        public Criteria andLogintimesNotEqualTo(Integer value) {
            addCriterion("LoginTimes <>", value, "logintimes");
            return (Criteria) this;
        }

        public Criteria andLogintimesGreaterThan(Integer value) {
            addCriterion("LoginTimes >", value, "logintimes");
            return (Criteria) this;
        }

        public Criteria andLogintimesGreaterThanOrEqualTo(Integer value) {
            addCriterion("LoginTimes >=", value, "logintimes");
            return (Criteria) this;
        }

        public Criteria andLogintimesLessThan(Integer value) {
            addCriterion("LoginTimes <", value, "logintimes");
            return (Criteria) this;
        }

        public Criteria andLogintimesLessThanOrEqualTo(Integer value) {
            addCriterion("LoginTimes <=", value, "logintimes");
            return (Criteria) this;
        }

        public Criteria andLogintimesIn(List<Integer> values) {
            addCriterion("LoginTimes in", values, "logintimes");
            return (Criteria) this;
        }

        public Criteria andLogintimesNotIn(List<Integer> values) {
            addCriterion("LoginTimes not in", values, "logintimes");
            return (Criteria) this;
        }

        public Criteria andLogintimesBetween(Integer value1, Integer value2) {
            addCriterion("LoginTimes between", value1, value2, "logintimes");
            return (Criteria) this;
        }

        public Criteria andLogintimesNotBetween(Integer value1, Integer value2) {
            addCriterion("LoginTimes not between", value1, value2, "logintimes");
            return (Criteria) this;
        }

        public Criteria andIssuenoIsNull() {
            addCriterion("IssueNo is null");
            return (Criteria) this;
        }

        public Criteria andIssuenoIsNotNull() {
            addCriterion("IssueNo is not null");
            return (Criteria) this;
        }

        public Criteria andIssuenoEqualTo(String value) {
            addCriterion("IssueNo =", value, "issueno");
            return (Criteria) this;
        }

        public Criteria andIssuenoNotEqualTo(String value) {
            addCriterion("IssueNo <>", value, "issueno");
            return (Criteria) this;
        }

        public Criteria andIssuenoGreaterThan(String value) {
            addCriterion("IssueNo >", value, "issueno");
            return (Criteria) this;
        }

        public Criteria andIssuenoGreaterThanOrEqualTo(String value) {
            addCriterion("IssueNo >=", value, "issueno");
            return (Criteria) this;
        }

        public Criteria andIssuenoLessThan(String value) {
            addCriterion("IssueNo <", value, "issueno");
            return (Criteria) this;
        }

        public Criteria andIssuenoLessThanOrEqualTo(String value) {
            addCriterion("IssueNo <=", value, "issueno");
            return (Criteria) this;
        }

        public Criteria andIssuenoLike(String value) {
            addCriterion("IssueNo like", value, "issueno");
            return (Criteria) this;
        }

        public Criteria andIssuenoNotLike(String value) {
            addCriterion("IssueNo not like", value, "issueno");
            return (Criteria) this;
        }

        public Criteria andIssuenoIn(List<String> values) {
            addCriterion("IssueNo in", values, "issueno");
            return (Criteria) this;
        }

        public Criteria andIssuenoNotIn(List<String> values) {
            addCriterion("IssueNo not in", values, "issueno");
            return (Criteria) this;
        }

        public Criteria andIssuenoBetween(String value1, String value2) {
            addCriterion("IssueNo between", value1, value2, "issueno");
            return (Criteria) this;
        }

        public Criteria andIssuenoNotBetween(String value1, String value2) {
            addCriterion("IssueNo not between", value1, value2, "issueno");
            return (Criteria) this;
        }

        public Criteria andIntroducerIsNull() {
            addCriterion("Introducer is null");
            return (Criteria) this;
        }

        public Criteria andIntroducerIsNotNull() {
            addCriterion("Introducer is not null");
            return (Criteria) this;
        }

        public Criteria andIntroducerEqualTo(String value) {
            addCriterion("Introducer =", value, "introducer");
            return (Criteria) this;
        }

        public Criteria andIntroducerNotEqualTo(String value) {
            addCriterion("Introducer <>", value, "introducer");
            return (Criteria) this;
        }

        public Criteria andIntroducerGreaterThan(String value) {
            addCriterion("Introducer >", value, "introducer");
            return (Criteria) this;
        }

        public Criteria andIntroducerGreaterThanOrEqualTo(String value) {
            addCriterion("Introducer >=", value, "introducer");
            return (Criteria) this;
        }

        public Criteria andIntroducerLessThan(String value) {
            addCriterion("Introducer <", value, "introducer");
            return (Criteria) this;
        }

        public Criteria andIntroducerLessThanOrEqualTo(String value) {
            addCriterion("Introducer <=", value, "introducer");
            return (Criteria) this;
        }

        public Criteria andIntroducerLike(String value) {
            addCriterion("Introducer like", value, "introducer");
            return (Criteria) this;
        }

        public Criteria andIntroducerNotLike(String value) {
            addCriterion("Introducer not like", value, "introducer");
            return (Criteria) this;
        }

        public Criteria andIntroducerIn(List<String> values) {
            addCriterion("Introducer in", values, "introducer");
            return (Criteria) this;
        }

        public Criteria andIntroducerNotIn(List<String> values) {
            addCriterion("Introducer not in", values, "introducer");
            return (Criteria) this;
        }

        public Criteria andIntroducerBetween(String value1, String value2) {
            addCriterion("Introducer between", value1, value2, "introducer");
            return (Criteria) this;
        }

        public Criteria andIntroducerNotBetween(String value1, String value2) {
            addCriterion("Introducer not between", value1, value2, "introducer");
            return (Criteria) this;
        }

        public Criteria andIntroduceridIsNull() {
            addCriterion("IntroducerID is null");
            return (Criteria) this;
        }

        public Criteria andIntroduceridIsNotNull() {
            addCriterion("IntroducerID is not null");
            return (Criteria) this;
        }

        public Criteria andIntroduceridEqualTo(String value) {
            addCriterion("IntroducerID =", value, "introducerid");
            return (Criteria) this;
        }

        public Criteria andIntroduceridNotEqualTo(String value) {
            addCriterion("IntroducerID <>", value, "introducerid");
            return (Criteria) this;
        }

        public Criteria andIntroduceridGreaterThan(String value) {
            addCriterion("IntroducerID >", value, "introducerid");
            return (Criteria) this;
        }

        public Criteria andIntroduceridGreaterThanOrEqualTo(String value) {
            addCriterion("IntroducerID >=", value, "introducerid");
            return (Criteria) this;
        }

        public Criteria andIntroduceridLessThan(String value) {
            addCriterion("IntroducerID <", value, "introducerid");
            return (Criteria) this;
        }

        public Criteria andIntroduceridLessThanOrEqualTo(String value) {
            addCriterion("IntroducerID <=", value, "introducerid");
            return (Criteria) this;
        }

        public Criteria andIntroduceridLike(String value) {
            addCriterion("IntroducerID like", value, "introducerid");
            return (Criteria) this;
        }

        public Criteria andIntroduceridNotLike(String value) {
            addCriterion("IntroducerID not like", value, "introducerid");
            return (Criteria) this;
        }

        public Criteria andIntroduceridIn(List<String> values) {
            addCriterion("IntroducerID in", values, "introducerid");
            return (Criteria) this;
        }

        public Criteria andIntroduceridNotIn(List<String> values) {
            addCriterion("IntroducerID not in", values, "introducerid");
            return (Criteria) this;
        }

        public Criteria andIntroduceridBetween(String value1, String value2) {
            addCriterion("IntroducerID between", value1, value2, "introducerid");
            return (Criteria) this;
        }

        public Criteria andIntroduceridNotBetween(String value1, String value2) {
            addCriterion("IntroducerID not between", value1, value2, "introducerid");
            return (Criteria) this;
        }

        public Criteria andBringinsIsNull() {
            addCriterion("BringIns is null");
            return (Criteria) this;
        }

        public Criteria andBringinsIsNotNull() {
            addCriterion("BringIns is not null");
            return (Criteria) this;
        }

        public Criteria andBringinsEqualTo(Integer value) {
            addCriterion("BringIns =", value, "bringins");
            return (Criteria) this;
        }

        public Criteria andBringinsNotEqualTo(Integer value) {
            addCriterion("BringIns <>", value, "bringins");
            return (Criteria) this;
        }

        public Criteria andBringinsGreaterThan(Integer value) {
            addCriterion("BringIns >", value, "bringins");
            return (Criteria) this;
        }

        public Criteria andBringinsGreaterThanOrEqualTo(Integer value) {
            addCriterion("BringIns >=", value, "bringins");
            return (Criteria) this;
        }

        public Criteria andBringinsLessThan(Integer value) {
            addCriterion("BringIns <", value, "bringins");
            return (Criteria) this;
        }

        public Criteria andBringinsLessThanOrEqualTo(Integer value) {
            addCriterion("BringIns <=", value, "bringins");
            return (Criteria) this;
        }

        public Criteria andBringinsIn(List<Integer> values) {
            addCriterion("BringIns in", values, "bringins");
            return (Criteria) this;
        }

        public Criteria andBringinsNotIn(List<Integer> values) {
            addCriterion("BringIns not in", values, "bringins");
            return (Criteria) this;
        }

        public Criteria andBringinsBetween(Integer value1, Integer value2) {
            addCriterion("BringIns between", value1, value2, "bringins");
            return (Criteria) this;
        }

        public Criteria andBringinsNotBetween(Integer value1, Integer value2) {
            addCriterion("BringIns not between", value1, value2, "bringins");
            return (Criteria) this;
        }

        public Criteria andProfitIsNull() {
            addCriterion("Profit is null");
            return (Criteria) this;
        }

        public Criteria andProfitIsNotNull() {
            addCriterion("Profit is not null");
            return (Criteria) this;
        }

        public Criteria andProfitEqualTo(BigDecimal value) {
            addCriterion("Profit =", value, "profit");
            return (Criteria) this;
        }

        public Criteria andProfitNotEqualTo(BigDecimal value) {
            addCriterion("Profit <>", value, "profit");
            return (Criteria) this;
        }

        public Criteria andProfitGreaterThan(BigDecimal value) {
            addCriterion("Profit >", value, "profit");
            return (Criteria) this;
        }

        public Criteria andProfitGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("Profit >=", value, "profit");
            return (Criteria) this;
        }

        public Criteria andProfitLessThan(BigDecimal value) {
            addCriterion("Profit <", value, "profit");
            return (Criteria) this;
        }

        public Criteria andProfitLessThanOrEqualTo(BigDecimal value) {
            addCriterion("Profit <=", value, "profit");
            return (Criteria) this;
        }

        public Criteria andProfitIn(List<BigDecimal> values) {
            addCriterion("Profit in", values, "profit");
            return (Criteria) this;
        }

        public Criteria andProfitNotIn(List<BigDecimal> values) {
            addCriterion("Profit not in", values, "profit");
            return (Criteria) this;
        }

        public Criteria andProfitBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("Profit between", value1, value2, "profit");
            return (Criteria) this;
        }

        public Criteria andProfitNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("Profit not between", value1, value2, "profit");
            return (Criteria) this;
        }

        public Criteria andDirectorydateIsNull() {
            addCriterion("DirectoryDate is null");
            return (Criteria) this;
        }

        public Criteria andDirectorydateIsNotNull() {
            addCriterion("DirectoryDate is not null");
            return (Criteria) this;
        }

        public Criteria andDirectorydateEqualTo(Date value) {
            addCriterion("DirectoryDate =", value, "directorydate");
            return (Criteria) this;
        }

        public Criteria andDirectorydateNotEqualTo(Date value) {
            addCriterion("DirectoryDate <>", value, "directorydate");
            return (Criteria) this;
        }

        public Criteria andDirectorydateGreaterThan(Date value) {
            addCriterion("DirectoryDate >", value, "directorydate");
            return (Criteria) this;
        }

        public Criteria andDirectorydateGreaterThanOrEqualTo(Date value) {
            addCriterion("DirectoryDate >=", value, "directorydate");
            return (Criteria) this;
        }

        public Criteria andDirectorydateLessThan(Date value) {
            addCriterion("DirectoryDate <", value, "directorydate");
            return (Criteria) this;
        }

        public Criteria andDirectorydateLessThanOrEqualTo(Date value) {
            addCriterion("DirectoryDate <=", value, "directorydate");
            return (Criteria) this;
        }

        public Criteria andDirectorydateIn(List<Date> values) {
            addCriterion("DirectoryDate in", values, "directorydate");
            return (Criteria) this;
        }

        public Criteria andDirectorydateNotIn(List<Date> values) {
            addCriterion("DirectoryDate not in", values, "directorydate");
            return (Criteria) this;
        }

        public Criteria andDirectorydateBetween(Date value1, Date value2) {
            addCriterion("DirectoryDate between", value1, value2, "directorydate");
            return (Criteria) this;
        }

        public Criteria andDirectorydateNotBetween(Date value1, Date value2) {
            addCriterion("DirectoryDate not between", value1, value2, "directorydate");
            return (Criteria) this;
        }

        public Criteria andDeveloperIsNull() {
            addCriterion("Developer is null");
            return (Criteria) this;
        }

        public Criteria andDeveloperIsNotNull() {
            addCriterion("Developer is not null");
            return (Criteria) this;
        }

        public Criteria andDeveloperEqualTo(String value) {
            addCriterion("Developer =", value, "developer");
            return (Criteria) this;
        }

        public Criteria andDeveloperNotEqualTo(String value) {
            addCriterion("Developer <>", value, "developer");
            return (Criteria) this;
        }

        public Criteria andDeveloperGreaterThan(String value) {
            addCriterion("Developer >", value, "developer");
            return (Criteria) this;
        }

        public Criteria andDeveloperGreaterThanOrEqualTo(String value) {
            addCriterion("Developer >=", value, "developer");
            return (Criteria) this;
        }

        public Criteria andDeveloperLessThan(String value) {
            addCriterion("Developer <", value, "developer");
            return (Criteria) this;
        }

        public Criteria andDeveloperLessThanOrEqualTo(String value) {
            addCriterion("Developer <=", value, "developer");
            return (Criteria) this;
        }

        public Criteria andDeveloperLike(String value) {
            addCriterion("Developer like", value, "developer");
            return (Criteria) this;
        }

        public Criteria andDeveloperNotLike(String value) {
            addCriterion("Developer not like", value, "developer");
            return (Criteria) this;
        }

        public Criteria andDeveloperIn(List<String> values) {
            addCriterion("Developer in", values, "developer");
            return (Criteria) this;
        }

        public Criteria andDeveloperNotIn(List<String> values) {
            addCriterion("Developer not in", values, "developer");
            return (Criteria) this;
        }

        public Criteria andDeveloperBetween(String value1, String value2) {
            addCriterion("Developer between", value1, value2, "developer");
            return (Criteria) this;
        }

        public Criteria andDeveloperNotBetween(String value1, String value2) {
            addCriterion("Developer not between", value1, value2, "developer");
            return (Criteria) this;
        }

        public Criteria andPrepaydepositIsNull() {
            addCriterion("PrepayDeposit is null");
            return (Criteria) this;
        }

        public Criteria andPrepaydepositIsNotNull() {
            addCriterion("PrepayDeposit is not null");
            return (Criteria) this;
        }

        public Criteria andPrepaydepositEqualTo(BigDecimal value) {
            addCriterion("PrepayDeposit =", value, "prepaydeposit");
            return (Criteria) this;
        }

        public Criteria andPrepaydepositNotEqualTo(BigDecimal value) {
            addCriterion("PrepayDeposit <>", value, "prepaydeposit");
            return (Criteria) this;
        }

        public Criteria andPrepaydepositGreaterThan(BigDecimal value) {
            addCriterion("PrepayDeposit >", value, "prepaydeposit");
            return (Criteria) this;
        }

        public Criteria andPrepaydepositGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("PrepayDeposit >=", value, "prepaydeposit");
            return (Criteria) this;
        }

        public Criteria andPrepaydepositLessThan(BigDecimal value) {
            addCriterion("PrepayDeposit <", value, "prepaydeposit");
            return (Criteria) this;
        }

        public Criteria andPrepaydepositLessThanOrEqualTo(BigDecimal value) {
            addCriterion("PrepayDeposit <=", value, "prepaydeposit");
            return (Criteria) this;
        }

        public Criteria andPrepaydepositIn(List<BigDecimal> values) {
            addCriterion("PrepayDeposit in", values, "prepaydeposit");
            return (Criteria) this;
        }

        public Criteria andPrepaydepositNotIn(List<BigDecimal> values) {
            addCriterion("PrepayDeposit not in", values, "prepaydeposit");
            return (Criteria) this;
        }

        public Criteria andPrepaydepositBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("PrepayDeposit between", value1, value2, "prepaydeposit");
            return (Criteria) this;
        }

        public Criteria andPrepaydepositNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("PrepayDeposit not between", value1, value2, "prepaydeposit");
            return (Criteria) this;
        }

        public Criteria andPrepaybonusIsNull() {
            addCriterion("PrepayBonus is null");
            return (Criteria) this;
        }

        public Criteria andPrepaybonusIsNotNull() {
            addCriterion("PrepayBonus is not null");
            return (Criteria) this;
        }

        public Criteria andPrepaybonusEqualTo(BigDecimal value) {
            addCriterion("PrepayBonus =", value, "prepaybonus");
            return (Criteria) this;
        }

        public Criteria andPrepaybonusNotEqualTo(BigDecimal value) {
            addCriterion("PrepayBonus <>", value, "prepaybonus");
            return (Criteria) this;
        }

        public Criteria andPrepaybonusGreaterThan(BigDecimal value) {
            addCriterion("PrepayBonus >", value, "prepaybonus");
            return (Criteria) this;
        }

        public Criteria andPrepaybonusGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("PrepayBonus >=", value, "prepaybonus");
            return (Criteria) this;
        }

        public Criteria andPrepaybonusLessThan(BigDecimal value) {
            addCriterion("PrepayBonus <", value, "prepaybonus");
            return (Criteria) this;
        }

        public Criteria andPrepaybonusLessThanOrEqualTo(BigDecimal value) {
            addCriterion("PrepayBonus <=", value, "prepaybonus");
            return (Criteria) this;
        }

        public Criteria andPrepaybonusIn(List<BigDecimal> values) {
            addCriterion("PrepayBonus in", values, "prepaybonus");
            return (Criteria) this;
        }

        public Criteria andPrepaybonusNotIn(List<BigDecimal> values) {
            addCriterion("PrepayBonus not in", values, "prepaybonus");
            return (Criteria) this;
        }

        public Criteria andPrepaybonusBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("PrepayBonus between", value1, value2, "prepaybonus");
            return (Criteria) this;
        }

        public Criteria andPrepaybonusNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("PrepayBonus not between", value1, value2, "prepaybonus");
            return (Criteria) this;
        }

        public Criteria andIscanmailIsNull() {
            addCriterion("IsCanMail is null");
            return (Criteria) this;
        }

        public Criteria andIscanmailIsNotNull() {
            addCriterion("IsCanMail is not null");
            return (Criteria) this;
        }

        public Criteria andIscanmailEqualTo(String value) {
            addCriterion("IsCanMail =", value, "iscanmail");
            return (Criteria) this;
        }

        public Criteria andIscanmailNotEqualTo(String value) {
            addCriterion("IsCanMail <>", value, "iscanmail");
            return (Criteria) this;
        }

        public Criteria andIscanmailGreaterThan(String value) {
            addCriterion("IsCanMail >", value, "iscanmail");
            return (Criteria) this;
        }

        public Criteria andIscanmailGreaterThanOrEqualTo(String value) {
            addCriterion("IsCanMail >=", value, "iscanmail");
            return (Criteria) this;
        }

        public Criteria andIscanmailLessThan(String value) {
            addCriterion("IsCanMail <", value, "iscanmail");
            return (Criteria) this;
        }

        public Criteria andIscanmailLessThanOrEqualTo(String value) {
            addCriterion("IsCanMail <=", value, "iscanmail");
            return (Criteria) this;
        }

        public Criteria andIscanmailLike(String value) {
            addCriterion("IsCanMail like", value, "iscanmail");
            return (Criteria) this;
        }

        public Criteria andIscanmailNotLike(String value) {
            addCriterion("IsCanMail not like", value, "iscanmail");
            return (Criteria) this;
        }

        public Criteria andIscanmailIn(List<String> values) {
            addCriterion("IsCanMail in", values, "iscanmail");
            return (Criteria) this;
        }

        public Criteria andIscanmailNotIn(List<String> values) {
            addCriterion("IsCanMail not in", values, "iscanmail");
            return (Criteria) this;
        }

        public Criteria andIscanmailBetween(String value1, String value2) {
            addCriterion("IsCanMail between", value1, value2, "iscanmail");
            return (Criteria) this;
        }

        public Criteria andIscanmailNotBetween(String value1, String value2) {
            addCriterion("IsCanMail not between", value1, value2, "iscanmail");
            return (Criteria) this;
        }

        public Criteria andIssuemanIsNull() {
            addCriterion("IssueMan is null");
            return (Criteria) this;
        }

        public Criteria andIssuemanIsNotNull() {
            addCriterion("IssueMan is not null");
            return (Criteria) this;
        }

        public Criteria andIssuemanEqualTo(String value) {
            addCriterion("IssueMan =", value, "issueman");
            return (Criteria) this;
        }

        public Criteria andIssuemanNotEqualTo(String value) {
            addCriterion("IssueMan <>", value, "issueman");
            return (Criteria) this;
        }

        public Criteria andIssuemanGreaterThan(String value) {
            addCriterion("IssueMan >", value, "issueman");
            return (Criteria) this;
        }

        public Criteria andIssuemanGreaterThanOrEqualTo(String value) {
            addCriterion("IssueMan >=", value, "issueman");
            return (Criteria) this;
        }

        public Criteria andIssuemanLessThan(String value) {
            addCriterion("IssueMan <", value, "issueman");
            return (Criteria) this;
        }

        public Criteria andIssuemanLessThanOrEqualTo(String value) {
            addCriterion("IssueMan <=", value, "issueman");
            return (Criteria) this;
        }

        public Criteria andIssuemanLike(String value) {
            addCriterion("IssueMan like", value, "issueman");
            return (Criteria) this;
        }

        public Criteria andIssuemanNotLike(String value) {
            addCriterion("IssueMan not like", value, "issueman");
            return (Criteria) this;
        }

        public Criteria andIssuemanIn(List<String> values) {
            addCriterion("IssueMan in", values, "issueman");
            return (Criteria) this;
        }

        public Criteria andIssuemanNotIn(List<String> values) {
            addCriterion("IssueMan not in", values, "issueman");
            return (Criteria) this;
        }

        public Criteria andIssuemanBetween(String value1, String value2) {
            addCriterion("IssueMan between", value1, value2, "issueman");
            return (Criteria) this;
        }

        public Criteria andIssuemanNotBetween(String value1, String value2) {
            addCriterion("IssueMan not between", value1, value2, "issueman");
            return (Criteria) this;
        }

        public Criteria andAccountstatusIsNull() {
            addCriterion("AccountStatus is null");
            return (Criteria) this;
        }

        public Criteria andAccountstatusIsNotNull() {
            addCriterion("AccountStatus is not null");
            return (Criteria) this;
        }

        public Criteria andAccountstatusEqualTo(String value) {
            addCriterion("AccountStatus =", value, "accountstatus");
            return (Criteria) this;
        }

        public Criteria andAccountstatusNotEqualTo(String value) {
            addCriterion("AccountStatus <>", value, "accountstatus");
            return (Criteria) this;
        }

        public Criteria andAccountstatusGreaterThan(String value) {
            addCriterion("AccountStatus >", value, "accountstatus");
            return (Criteria) this;
        }

        public Criteria andAccountstatusGreaterThanOrEqualTo(String value) {
            addCriterion("AccountStatus >=", value, "accountstatus");
            return (Criteria) this;
        }

        public Criteria andAccountstatusLessThan(String value) {
            addCriterion("AccountStatus <", value, "accountstatus");
            return (Criteria) this;
        }

        public Criteria andAccountstatusLessThanOrEqualTo(String value) {
            addCriterion("AccountStatus <=", value, "accountstatus");
            return (Criteria) this;
        }

        public Criteria andAccountstatusLike(String value) {
            addCriterion("AccountStatus like", value, "accountstatus");
            return (Criteria) this;
        }

        public Criteria andAccountstatusNotLike(String value) {
            addCriterion("AccountStatus not like", value, "accountstatus");
            return (Criteria) this;
        }

        public Criteria andAccountstatusIn(List<String> values) {
            addCriterion("AccountStatus in", values, "accountstatus");
            return (Criteria) this;
        }

        public Criteria andAccountstatusNotIn(List<String> values) {
            addCriterion("AccountStatus not in", values, "accountstatus");
            return (Criteria) this;
        }

        public Criteria andAccountstatusBetween(String value1, String value2) {
            addCriterion("AccountStatus between", value1, value2, "accountstatus");
            return (Criteria) this;
        }

        public Criteria andAccountstatusNotBetween(String value1, String value2) {
            addCriterion("AccountStatus not between", value1, value2, "accountstatus");
            return (Criteria) this;
        }

        public Criteria andDeliverdateIsNull() {
            addCriterion("DeliverDate is null");
            return (Criteria) this;
        }

        public Criteria andDeliverdateIsNotNull() {
            addCriterion("DeliverDate is not null");
            return (Criteria) this;
        }

        public Criteria andDeliverdateEqualTo(Date value) {
            addCriterion("DeliverDate =", value, "deliverdate");
            return (Criteria) this;
        }

        public Criteria andDeliverdateNotEqualTo(Date value) {
            addCriterion("DeliverDate <>", value, "deliverdate");
            return (Criteria) this;
        }

        public Criteria andDeliverdateGreaterThan(Date value) {
            addCriterion("DeliverDate >", value, "deliverdate");
            return (Criteria) this;
        }

        public Criteria andDeliverdateGreaterThanOrEqualTo(Date value) {
            addCriterion("DeliverDate >=", value, "deliverdate");
            return (Criteria) this;
        }

        public Criteria andDeliverdateLessThan(Date value) {
            addCriterion("DeliverDate <", value, "deliverdate");
            return (Criteria) this;
        }

        public Criteria andDeliverdateLessThanOrEqualTo(Date value) {
            addCriterion("DeliverDate <=", value, "deliverdate");
            return (Criteria) this;
        }

        public Criteria andDeliverdateIn(List<Date> values) {
            addCriterion("DeliverDate in", values, "deliverdate");
            return (Criteria) this;
        }

        public Criteria andDeliverdateNotIn(List<Date> values) {
            addCriterion("DeliverDate not in", values, "deliverdate");
            return (Criteria) this;
        }

        public Criteria andDeliverdateBetween(Date value1, Date value2) {
            addCriterion("DeliverDate between", value1, value2, "deliverdate");
            return (Criteria) this;
        }

        public Criteria andDeliverdateNotBetween(Date value1, Date value2) {
            addCriterion("DeliverDate not between", value1, value2, "deliverdate");
            return (Criteria) this;
        }

        public Criteria andLostdateIsNull() {
            addCriterion("LostDate is null");
            return (Criteria) this;
        }

        public Criteria andLostdateIsNotNull() {
            addCriterion("LostDate is not null");
            return (Criteria) this;
        }

        public Criteria andLostdateEqualTo(Date value) {
            addCriterion("LostDate =", value, "lostdate");
            return (Criteria) this;
        }

        public Criteria andLostdateNotEqualTo(Date value) {
            addCriterion("LostDate <>", value, "lostdate");
            return (Criteria) this;
        }

        public Criteria andLostdateGreaterThan(Date value) {
            addCriterion("LostDate >", value, "lostdate");
            return (Criteria) this;
        }

        public Criteria andLostdateGreaterThanOrEqualTo(Date value) {
            addCriterion("LostDate >=", value, "lostdate");
            return (Criteria) this;
        }

        public Criteria andLostdateLessThan(Date value) {
            addCriterion("LostDate <", value, "lostdate");
            return (Criteria) this;
        }

        public Criteria andLostdateLessThanOrEqualTo(Date value) {
            addCriterion("LostDate <=", value, "lostdate");
            return (Criteria) this;
        }

        public Criteria andLostdateIn(List<Date> values) {
            addCriterion("LostDate in", values, "lostdate");
            return (Criteria) this;
        }

        public Criteria andLostdateNotIn(List<Date> values) {
            addCriterion("LostDate not in", values, "lostdate");
            return (Criteria) this;
        }

        public Criteria andLostdateBetween(Date value1, Date value2) {
            addCriterion("LostDate between", value1, value2, "lostdate");
            return (Criteria) this;
        }

        public Criteria andLostdateNotBetween(Date value1, Date value2) {
            addCriterion("LostDate not between", value1, value2, "lostdate");
            return (Criteria) this;
        }

        public Criteria andTotalprepayIsNull() {
            addCriterion("TotalPrepay is null");
            return (Criteria) this;
        }

        public Criteria andTotalprepayIsNotNull() {
            addCriterion("TotalPrepay is not null");
            return (Criteria) this;
        }

        public Criteria andTotalprepayEqualTo(BigDecimal value) {
            addCriterion("TotalPrepay =", value, "totalprepay");
            return (Criteria) this;
        }

        public Criteria andTotalprepayNotEqualTo(BigDecimal value) {
            addCriterion("TotalPrepay <>", value, "totalprepay");
            return (Criteria) this;
        }

        public Criteria andTotalprepayGreaterThan(BigDecimal value) {
            addCriterion("TotalPrepay >", value, "totalprepay");
            return (Criteria) this;
        }

        public Criteria andTotalprepayGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("TotalPrepay >=", value, "totalprepay");
            return (Criteria) this;
        }

        public Criteria andTotalprepayLessThan(BigDecimal value) {
            addCriterion("TotalPrepay <", value, "totalprepay");
            return (Criteria) this;
        }

        public Criteria andTotalprepayLessThanOrEqualTo(BigDecimal value) {
            addCriterion("TotalPrepay <=", value, "totalprepay");
            return (Criteria) this;
        }

        public Criteria andTotalprepayIn(List<BigDecimal> values) {
            addCriterion("TotalPrepay in", values, "totalprepay");
            return (Criteria) this;
        }

        public Criteria andTotalprepayNotIn(List<BigDecimal> values) {
            addCriterion("TotalPrepay not in", values, "totalprepay");
            return (Criteria) this;
        }

        public Criteria andTotalprepayBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("TotalPrepay between", value1, value2, "totalprepay");
            return (Criteria) this;
        }

        public Criteria andTotalprepayNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("TotalPrepay not between", value1, value2, "totalprepay");
            return (Criteria) this;
        }

        public Criteria andIscansendmsgIsNull() {
            addCriterion("IsCanSendMsg is null");
            return (Criteria) this;
        }

        public Criteria andIscansendmsgIsNotNull() {
            addCriterion("IsCanSendMsg is not null");
            return (Criteria) this;
        }

        public Criteria andIscansendmsgEqualTo(String value) {
            addCriterion("IsCanSendMsg =", value, "iscansendmsg");
            return (Criteria) this;
        }

        public Criteria andIscansendmsgNotEqualTo(String value) {
            addCriterion("IsCanSendMsg <>", value, "iscansendmsg");
            return (Criteria) this;
        }

        public Criteria andIscansendmsgGreaterThan(String value) {
            addCriterion("IsCanSendMsg >", value, "iscansendmsg");
            return (Criteria) this;
        }

        public Criteria andIscansendmsgGreaterThanOrEqualTo(String value) {
            addCriterion("IsCanSendMsg >=", value, "iscansendmsg");
            return (Criteria) this;
        }

        public Criteria andIscansendmsgLessThan(String value) {
            addCriterion("IsCanSendMsg <", value, "iscansendmsg");
            return (Criteria) this;
        }

        public Criteria andIscansendmsgLessThanOrEqualTo(String value) {
            addCriterion("IsCanSendMsg <=", value, "iscansendmsg");
            return (Criteria) this;
        }

        public Criteria andIscansendmsgLike(String value) {
            addCriterion("IsCanSendMsg like", value, "iscansendmsg");
            return (Criteria) this;
        }

        public Criteria andIscansendmsgNotLike(String value) {
            addCriterion("IsCanSendMsg not like", value, "iscansendmsg");
            return (Criteria) this;
        }

        public Criteria andIscansendmsgIn(List<String> values) {
            addCriterion("IsCanSendMsg in", values, "iscansendmsg");
            return (Criteria) this;
        }

        public Criteria andIscansendmsgNotIn(List<String> values) {
            addCriterion("IsCanSendMsg not in", values, "iscansendmsg");
            return (Criteria) this;
        }

        public Criteria andIscansendmsgBetween(String value1, String value2) {
            addCriterion("IsCanSendMsg between", value1, value2, "iscansendmsg");
            return (Criteria) this;
        }

        public Criteria andIscansendmsgNotBetween(String value1, String value2) {
            addCriterion("IsCanSendMsg not between", value1, value2, "iscansendmsg");
            return (Criteria) this;
        }

        public Criteria andTotalbackIsNull() {
            addCriterion("TotalBack is null");
            return (Criteria) this;
        }

        public Criteria andTotalbackIsNotNull() {
            addCriterion("TotalBack is not null");
            return (Criteria) this;
        }

        public Criteria andTotalbackEqualTo(BigDecimal value) {
            addCriterion("TotalBack =", value, "totalback");
            return (Criteria) this;
        }

        public Criteria andTotalbackNotEqualTo(BigDecimal value) {
            addCriterion("TotalBack <>", value, "totalback");
            return (Criteria) this;
        }

        public Criteria andTotalbackGreaterThan(BigDecimal value) {
            addCriterion("TotalBack >", value, "totalback");
            return (Criteria) this;
        }

        public Criteria andTotalbackGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("TotalBack >=", value, "totalback");
            return (Criteria) this;
        }

        public Criteria andTotalbackLessThan(BigDecimal value) {
            addCriterion("TotalBack <", value, "totalback");
            return (Criteria) this;
        }

        public Criteria andTotalbackLessThanOrEqualTo(BigDecimal value) {
            addCriterion("TotalBack <=", value, "totalback");
            return (Criteria) this;
        }

        public Criteria andTotalbackIn(List<BigDecimal> values) {
            addCriterion("TotalBack in", values, "totalback");
            return (Criteria) this;
        }

        public Criteria andTotalbackNotIn(List<BigDecimal> values) {
            addCriterion("TotalBack not in", values, "totalback");
            return (Criteria) this;
        }

        public Criteria andTotalbackBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("TotalBack between", value1, value2, "totalback");
            return (Criteria) this;
        }

        public Criteria andTotalbackNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("TotalBack not between", value1, value2, "totalback");
            return (Criteria) this;
        }

        public Criteria andAgerangeIsNull() {
            addCriterion("AgeRange is null");
            return (Criteria) this;
        }

        public Criteria andAgerangeIsNotNull() {
            addCriterion("AgeRange is not null");
            return (Criteria) this;
        }

        public Criteria andAgerangeEqualTo(String value) {
            addCriterion("AgeRange =", value, "agerange");
            return (Criteria) this;
        }

        public Criteria andAgerangeNotEqualTo(String value) {
            addCriterion("AgeRange <>", value, "agerange");
            return (Criteria) this;
        }

        public Criteria andAgerangeGreaterThan(String value) {
            addCriterion("AgeRange >", value, "agerange");
            return (Criteria) this;
        }

        public Criteria andAgerangeGreaterThanOrEqualTo(String value) {
            addCriterion("AgeRange >=", value, "agerange");
            return (Criteria) this;
        }

        public Criteria andAgerangeLessThan(String value) {
            addCriterion("AgeRange <", value, "agerange");
            return (Criteria) this;
        }

        public Criteria andAgerangeLessThanOrEqualTo(String value) {
            addCriterion("AgeRange <=", value, "agerange");
            return (Criteria) this;
        }

        public Criteria andAgerangeLike(String value) {
            addCriterion("AgeRange like", value, "agerange");
            return (Criteria) this;
        }

        public Criteria andAgerangeNotLike(String value) {
            addCriterion("AgeRange not like", value, "agerange");
            return (Criteria) this;
        }

        public Criteria andAgerangeIn(List<String> values) {
            addCriterion("AgeRange in", values, "agerange");
            return (Criteria) this;
        }

        public Criteria andAgerangeNotIn(List<String> values) {
            addCriterion("AgeRange not in", values, "agerange");
            return (Criteria) this;
        }

        public Criteria andAgerangeBetween(String value1, String value2) {
            addCriterion("AgeRange between", value1, value2, "agerange");
            return (Criteria) this;
        }

        public Criteria andAgerangeNotBetween(String value1, String value2) {
            addCriterion("AgeRange not between", value1, value2, "agerange");
            return (Criteria) this;
        }

        public Criteria andFreezepointIsNull() {
            addCriterion("FreezePoint is null");
            return (Criteria) this;
        }

        public Criteria andFreezepointIsNotNull() {
            addCriterion("FreezePoint is not null");
            return (Criteria) this;
        }

        public Criteria andFreezepointEqualTo(BigDecimal value) {
            addCriterion("FreezePoint =", value, "freezepoint");
            return (Criteria) this;
        }

        public Criteria andFreezepointNotEqualTo(BigDecimal value) {
            addCriterion("FreezePoint <>", value, "freezepoint");
            return (Criteria) this;
        }

        public Criteria andFreezepointGreaterThan(BigDecimal value) {
            addCriterion("FreezePoint >", value, "freezepoint");
            return (Criteria) this;
        }

        public Criteria andFreezepointGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("FreezePoint >=", value, "freezepoint");
            return (Criteria) this;
        }

        public Criteria andFreezepointLessThan(BigDecimal value) {
            addCriterion("FreezePoint <", value, "freezepoint");
            return (Criteria) this;
        }

        public Criteria andFreezepointLessThanOrEqualTo(BigDecimal value) {
            addCriterion("FreezePoint <=", value, "freezepoint");
            return (Criteria) this;
        }

        public Criteria andFreezepointIn(List<BigDecimal> values) {
            addCriterion("FreezePoint in", values, "freezepoint");
            return (Criteria) this;
        }

        public Criteria andFreezepointNotIn(List<BigDecimal> values) {
            addCriterion("FreezePoint not in", values, "freezepoint");
            return (Criteria) this;
        }

        public Criteria andFreezepointBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("FreezePoint between", value1, value2, "freezepoint");
            return (Criteria) this;
        }

        public Criteria andFreezepointNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("FreezePoint not between", value1, value2, "freezepoint");
            return (Criteria) this;
        }

        public Criteria andPlacenoIsNull() {
            addCriterion("PlaceNo is null");
            return (Criteria) this;
        }

        public Criteria andPlacenoIsNotNull() {
            addCriterion("PlaceNo is not null");
            return (Criteria) this;
        }

        public Criteria andPlacenoEqualTo(String value) {
            addCriterion("PlaceNo =", value, "placeno");
            return (Criteria) this;
        }

        public Criteria andPlacenoNotEqualTo(String value) {
            addCriterion("PlaceNo <>", value, "placeno");
            return (Criteria) this;
        }

        public Criteria andPlacenoGreaterThan(String value) {
            addCriterion("PlaceNo >", value, "placeno");
            return (Criteria) this;
        }

        public Criteria andPlacenoGreaterThanOrEqualTo(String value) {
            addCriterion("PlaceNo >=", value, "placeno");
            return (Criteria) this;
        }

        public Criteria andPlacenoLessThan(String value) {
            addCriterion("PlaceNo <", value, "placeno");
            return (Criteria) this;
        }

        public Criteria andPlacenoLessThanOrEqualTo(String value) {
            addCriterion("PlaceNo <=", value, "placeno");
            return (Criteria) this;
        }

        public Criteria andPlacenoLike(String value) {
            addCriterion("PlaceNo like", value, "placeno");
            return (Criteria) this;
        }

        public Criteria andPlacenoNotLike(String value) {
            addCriterion("PlaceNo not like", value, "placeno");
            return (Criteria) this;
        }

        public Criteria andPlacenoIn(List<String> values) {
            addCriterion("PlaceNo in", values, "placeno");
            return (Criteria) this;
        }

        public Criteria andPlacenoNotIn(List<String> values) {
            addCriterion("PlaceNo not in", values, "placeno");
            return (Criteria) this;
        }

        public Criteria andPlacenoBetween(String value1, String value2) {
            addCriterion("PlaceNo between", value1, value2, "placeno");
            return (Criteria) this;
        }

        public Criteria andPlacenoNotBetween(String value1, String value2) {
            addCriterion("PlaceNo not between", value1, value2, "placeno");
            return (Criteria) this;
        }

        public Criteria andAddressidIsNull() {
            addCriterion("AddressID is null");
            return (Criteria) this;
        }

        public Criteria andAddressidIsNotNull() {
            addCriterion("AddressID is not null");
            return (Criteria) this;
        }

        public Criteria andAddressidEqualTo(Long value) {
            addCriterion("AddressID =", value, "addressid");
            return (Criteria) this;
        }

        public Criteria andAddressidNotEqualTo(Long value) {
            addCriterion("AddressID <>", value, "addressid");
            return (Criteria) this;
        }

        public Criteria andAddressidGreaterThan(Long value) {
            addCriterion("AddressID >", value, "addressid");
            return (Criteria) this;
        }

        public Criteria andAddressidGreaterThanOrEqualTo(Long value) {
            addCriterion("AddressID >=", value, "addressid");
            return (Criteria) this;
        }

        public Criteria andAddressidLessThan(Long value) {
            addCriterion("AddressID <", value, "addressid");
            return (Criteria) this;
        }

        public Criteria andAddressidLessThanOrEqualTo(Long value) {
            addCriterion("AddressID <=", value, "addressid");
            return (Criteria) this;
        }

        public Criteria andAddressidIn(List<Long> values) {
            addCriterion("AddressID in", values, "addressid");
            return (Criteria) this;
        }

        public Criteria andAddressidNotIn(List<Long> values) {
            addCriterion("AddressID not in", values, "addressid");
            return (Criteria) this;
        }

        public Criteria andAddressidBetween(Long value1, Long value2) {
            addCriterion("AddressID between", value1, value2, "addressid");
            return (Criteria) this;
        }

        public Criteria andAddressidNotBetween(Long value1, Long value2) {
            addCriterion("AddressID not between", value1, value2, "addressid");
            return (Criteria) this;
        }

        public Criteria andBalancedateIsNull() {
            addCriterion("BalanceDate is null");
            return (Criteria) this;
        }

        public Criteria andBalancedateIsNotNull() {
            addCriterion("BalanceDate is not null");
            return (Criteria) this;
        }

        public Criteria andBalancedateEqualTo(Date value) {
            addCriterion("BalanceDate =", value, "balancedate");
            return (Criteria) this;
        }

        public Criteria andBalancedateNotEqualTo(Date value) {
            addCriterion("BalanceDate <>", value, "balancedate");
            return (Criteria) this;
        }

        public Criteria andBalancedateGreaterThan(Date value) {
            addCriterion("BalanceDate >", value, "balancedate");
            return (Criteria) this;
        }

        public Criteria andBalancedateGreaterThanOrEqualTo(Date value) {
            addCriterion("BalanceDate >=", value, "balancedate");
            return (Criteria) this;
        }

        public Criteria andBalancedateLessThan(Date value) {
            addCriterion("BalanceDate <", value, "balancedate");
            return (Criteria) this;
        }

        public Criteria andBalancedateLessThanOrEqualTo(Date value) {
            addCriterion("BalanceDate <=", value, "balancedate");
            return (Criteria) this;
        }

        public Criteria andBalancedateIn(List<Date> values) {
            addCriterion("BalanceDate in", values, "balancedate");
            return (Criteria) this;
        }

        public Criteria andBalancedateNotIn(List<Date> values) {
            addCriterion("BalanceDate not in", values, "balancedate");
            return (Criteria) this;
        }

        public Criteria andBalancedateBetween(Date value1, Date value2) {
            addCriterion("BalanceDate between", value1, value2, "balancedate");
            return (Criteria) this;
        }

        public Criteria andBalancedateNotBetween(Date value1, Date value2) {
            addCriterion("BalanceDate not between", value1, value2, "balancedate");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}